cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YongJiang
Helper II
Helper II

Export data option disappears after publishing on web

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

2 ACCEPTED SOLUTIONS
venal
Memorable Member
Memorable Member

@YongJiang 

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 @

 

@venal 

View solution in original post

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.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

12 REPLIES 12
venal
Memorable Member
Memorable Member

@YongJiang 

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 @

 

@venal 

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.

v-xuding-msft_0-1595991190933.png

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.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

 

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#set-the-export-...

 
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.. 

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Xue Ding.

That's okay  - it's good to know.

Kind regards

Yong

venal
Memorable Member
Memorable Member

@YongJiang 

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 @

 

@venal 

View solution in original post

I've done it here - it seemed Microsoft disabled the feature?

https://ideas.powerbi.com/ideas/idea/?ideaid=a4b1bfe0-bee4-46df-8b0d-7fac183db1cf

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!