Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
We have tried to publish our first ever power bi book onto internet, only to find that the visuals have lost the three dot points on the top right corner of all the visuals. This means users cannot export any data from the visuals at all. We have published the power bi book through 'Publish to Web' approach, which was to select 'Publish to web' function under File to generate the embed code. Before doing this, I have set the Export Data option to 'Summarised data'. My version of power bi is May 2019, not that new but should still be good enough?
Any ideas to enable data export on internet would be greately appreciated.
Regards
Yong
Solved! Go to Solution.
Please post your idea in "Power BI Ideas Forum Page" for future release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
Hi @YongJiang ,
It is not supported all the time. Not MS disable the feature recently.
You could vote up this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=538de3f3-3140-4701-9eac-a07377bcb257. It has been voted by 400+ users. And this one voted by 80+: https://ideas.powerbi.com/ideas/idea/?ideaid=e510ce91-8ac5-4071-b5c7-c15fb443cd7c. I think the feature will be fixed soon.
Can you please check the setting in "Admin Portal".
Path:- Power BI Service >> Settings >> Admin Portal >> Tenant Settings >> Export and Sharing Settings >> EXport Data (Enable).
Please refer the below link for reference.
https://docs.microsoft.com/en-us/power-bi/guidance/admin-tenant-settings#export-data
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
Thank you Venal for your prompt reply. But my intention is to publish the power bi book on internet for it to be seen by anybody of the public in the world, not just within my organisation. I am wondering if the Tenant Admin work on the setting is able to help with this at all. And I just found i could simply use the 'Embed' function (instead of 'Publish to web') to generate the code for embedding, and am hoping that may enable data export.
Thanks again,
Yong
Hi @YongJiang ,
For now, it is not supported to export data from a report which has been published to web.
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#limitations
As you said, you could embed report to your own website or SharePoint. In that way, we can export data.
Thanks XueDing. Do you know if Microsoft would enable data export in future?
Yong
Hi @YongJiang ,
It is not supported all the time. Not MS disable the feature recently.
You could vote up this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=538de3f3-3140-4701-9eac-a07377bcb257. It has been voted by 400+ users. And this one voted by 80+: https://ideas.powerbi.com/ideas/idea/?ideaid=e510ce91-8ac5-4071-b5c7-c15fb443cd7c. I think the feature will be fixed soon.
That would be wonderful and extremely encouraging! Thanks Xue Ding for the great news!
One question though - we are using Power BI May 2919 version. If the Export Data feature is installed through 'Publish to web', would we be able to use the feature through this old version? I don't know if it has anything to do with the desktop version here. Sorry we are using the old version because our report server does not take newer version in our organisation. We have to keep going with the old one.
Hi @YongJiang ,
Don't worry. It is used in Service and not influenced by the Desktop version.
There is an option of exporting data in Desktop. It can restrict users to use the feature.
File > Options and settings > Options > Report settings > Export data
Thank you Xue Ding for the advice! Great to learn the old version won't be affected.
The last question - i promise - when do you think the feature of data export from 'Publish to web' would be fixed? We are planning to publish our power bi book on web in Sept. We are in the process of preparing all the stuff including Help notes etc. If we could use the feature by Sept this year we'll be able to keep our current version of prepared notes. If not, we need to change a lot of things, including perhaps updating our exsiting Excel books on the web.
Thanks heaps for your promt replies. Really apprciated.
kind regards
Yong
Hi @YongJiang ,
This document is about new and planed feature for Power BI. I don't find a plan about exporting data from published report. Sadly, it may be not released before Sep..
Thank you Xue Ding.
That's okay - it's good to know.
Kind regards
Yong
Please post your idea in "Power BI Ideas Forum Page" for future release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
I've done it here - it seemed Microsoft disabled the feature?
https://ideas.powerbi.com/ideas/idea/?ideaid=a4b1bfe0-bee4-46df-8b0d-7fac183db1cf