Forum Discussion
Missing button to export data to excel
Hi everyone!
I have a report that is published online (embbeded).
This project has different visuals and pivot tables but unfortunately I'm running through some problems when trying to download data from it to excel or a similar file.
Here is an example, where the option to export data is not showing:
Even when clicking with the right button on the pivot table, it doesn't show any option to download the data.
Do you have any idea what I might be doing wrong?
Is it a limitation? Would Power Automate be a solution for that?
Any questions, let me know!
Yes, I checked it. Thanks for answering, by the way...
I'm guessing the "problem" is in the publish to web option. For security reasons (like you said), Microsoft might've blocked this option so "public users" can't have access to the report data.
I will stop using the publish to web option.
Thanks, everyone!!!
6 Replies
Hi jonasemds ,
Do you mean you didn't have this option?
Testing the report in my service, this option is available.
I didn't understand clearly this statement. Where did you encounter the problem, in the service or did you publish or embedded it elsewhere?
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, Anonymous
Sorry for not explaining it clearly. And yes, this is the button I need to use (export data).
The project is in the Power BI Service and, there, the button to export is available.
However, I embedded it on my website. Then, with the report embedded on my website, the option don't appear.
I embedded it using the option "publish to web (public)" that is available in the Power BI Service.did you check the options in de PBi desktop file? that is where you allow or block the option to export to excel.
I'm not familiar with the embed on the web because we use PBI within our organisation. publish tp web open your data to the public which is why we don't use it.
You could check the settings in power bi desktop where you built the report.
open the pbix, file -> options and setting -> options, scroll down to current file -> report settings and check that you have allowed exporting data to excel.
