1

When published on the web (public) the power bi has limitations in the export of data see link https://learn.microsoft.com/en-us/power-bi/service-publish-to-web

Limitations

Publish to web is supported for the vast majority of data sources and reports in the Power BI service, however, the following are not currently supported or available with Publish to web:

  • Reports using row level security.
  • Reports using any Live Connection data source, including Analysis -Services Tabular hosted on-premises, Analysis Services -Multidimensional, and Azure Analysis Services.
  • Reports shared to you directly or through an organizational content pack.
  • Reports in a group in which you are not an edit member.
  • "R" Visuals are not currently supported in Publish to web reports.
  • Exporting Data from visuals in a report, which has been published to the web.
  • ArcGIS Maps for Power BI visuals.
  • Reports containing report-level DAX measures.
  • Single sign-on data query models.
  • Secure confidential or proprietary information.
  • Shared and certified datasets. The automatic authentication capability provided with the Embed option doesn't work with the Power BI JavaScript API. For the Power BI JavaScript API, use the user owns data approach to embedding.

The code embedded in iframe is not the solution .. any idea?

Improve this question
2
  • Don't use Power BI for exporting the data - export it directly from the data source, which is used by your report instead. Commented Jan 8, 2020 at 15:05
  • Please I did not understand your answer. How export it directly from the data source ?? ... send me a image Commented Jan 8, 2020 at 17:25

1 Answer 1

Reset to default
0

Publish to Web is free and comes with those restrictions.

Full-function embedding of Power BI Analytics is available either through Power BI Premium or the Power BI Embedded Service in Azure.

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

I know the limitations and have the power bi pro license, but could you create a report with power bi report builder and export it?
Sure. You could use Power BI Report Builder to export to Excel, Word, PDF, CSV, etc.
when published the report Power Pro, I requested a license premium
Yes. Currently you can only publish a paginated report to a Workspace hosted on a Premium Capacity. But anyone can use Power BI Report Builder on their desktop.
@AngelValverde if Premium is too expensive for your purposes you may consider usage of another BI tool, for example in SeekTable with $25/mo subscription you may publish to web 'live connection' reports with exports (including multi-page PDF) up to 50k rows (disclaimer: I'm affiliated with this product).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.