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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors