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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
pjg
Frequent Visitor

Issues exporting underlying data from published report from app.powerbi.com

Hi,
Im quite new to Power BI. Been enjoying things so far.

I have come across an issue that I can't seem to resolve. Ive been searching, tested a lot of things, but hit a dead end on what else to try.

The problem is I have a Metrix chart object on a published report that does a sum of values to display a %.

On app.powerbi.com, in the published report, when I click on the Metirx chart objects kebab menu "..." and select "Export Data", then select "Underlying data" and click [Export], I get a dialog that doesn't go away.
"Exporting data.
You can still browse reports and dashboards while we export your data"
Most of the time, this dialog just sits with a spinning circle and never finishes. I have left it over an hour.
If I keep trying it at different times, eventually it exports quickly.

I have checked the desktop PBI file and the "Export Data" is set to "Allow end users to export data with current layout, summarized data and underlying data from the service or Report Server".

I have checked my permissions on the Workspace DataSet for the report under Manage permissions and I have them all including the required "Allow recipients to build content with the data associated with this dataset".

Has anyone got any other ideas. Ive been searching but hit a dead end on what else to try.
Many thanks in advance.

1 ACCEPTED SOLUTION
pjg
Frequent Visitor

Workaround was to create a bookmark to a NEW page that showed the underlying data in a table with relevant slicers. This allowed additional conditional colour formatting of the background of some of the cells etc.
Still not sure why this happens, but at least this workaround works.

View solution in original post

3 REPLIES 3
pjg
Frequent Visitor

Workaround was to create a bookmark to a NEW page that showed the underlying data in a table with relevant slicers. This allowed additional conditional colour formatting of the background of some of the cells etc.
Still not sure why this happens, but at least this workaround works.

v-binbinyu-msft
Community Support
Community Support

Hi @pjg ,

I'm a little confused about your needs, Could you please explain them further?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

I have a Metirx chart object that shows a summary of data as a %.

I right click the ... menu and export the Underlying data and the "Exporting data" dialog stays on the screen and doesn't export the data.

 

 Export Underlying Data not working.png

 

This happens most of the time, but if I keep trying throughout the day, at some point, it exports the data fine in just a couple of seconds.

It doesn't seems to be a permission issue with the PBIX or my permission on the workspace, so I was wondering if anyone could help point me in the direction of other things to check or if someone else had has this problem and what they did to work around it.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors