Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
miguel1206
Helper II
Helper II

Export data to Excel from Embed code link

Hi all,

 

I would like to know if there is a way to export data to Excel from a dashbard that have been sent with Embed code link

 

Best regards

1 ACCEPTED SOLUTION

Hi there

That is using Publish to Web and as part of using Publish to Web one of the limitations are that you cannot export the data.

https://docs.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
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. Learn more about user owns data.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

7 REPLIES 7
shawntbenson
New Member

This is the number one complaint about Power BI that I get from our end users... inability to export report contents to Excel from embedded links. Of all possible enhancements, this is the ones that would be the biggest game changer for my organization.

ferzfeld
Advocate II
Advocate II

I think I might have the exact same question?

 

When using the generated embed link ("Securely embed this report in a website or portal"), the user is not presented with the dialogue to choose wether to Export as Excel or CSV (Picture 1)

 

Instead, after a few seconds of time the user can download the data as .CSV (Picture 2) - no possibility to choose between Excel or CSV or any other options.

 

Any way to have that option Excel-File or CSV when using the embed-link?

 

Thank you!

 

2019-03-01_11h23_00.png2019-03-01_11h26_02.png

 

GilbertQ
Super User
Super User

Hi @miguel1206 

 

Do you mean export data from a dashboard tile?

 

If so you can do it by clicking on the Ellipses

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ

 

Thank you for your response 

 

I mean using the Embed code link (not in the PowerBI.com portal) I haven't the option to export data of a tile to a .csv or excel files 

 

Best regards

 

Hi there

I think that this might be possible if you are referring to Power BI Embedded?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi GilbertQ,

 

Thanks for your response,

 

As an example, when I see the dashboard in PowerBI.com and click on 'more options' in the every tile I see the options to Export to Excel:

tile1.PNG

Then I create the embed code to create the link and send in mail 

tile2.PNG

And open in another page:

 

Here doesn't exists the option 'more options' to export data to Excel

 

Best regards 

Hi there

That is using Publish to Web and as part of using Publish to Web one of the limitations are that you cannot export the data.

https://docs.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
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. Learn more about user owns data.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors