Forum Discussion
Missing button to export data to excel
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!!!
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.
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!!!Hmm that does sound like it could be the reason.
The other thing that just popped up is that when you publish a report to a workspace, you also publish a dataset. When exporting to excel it's the dataset that is referenced.
When embeddeing a report on a site, no dataset is included as far as i know. so it's possible that only the report and functionality are published.
Hope you find another way to accomplish your task.