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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ajaramil
Frequent Visitor

Admin/owner unable to view exported data for reports

Hello, I am unable to view exported report data for every Power BI report I have. I receive two error messages after choosing Export > Analyze in Excel > Open in Excel for the Web. The first error is shown in Screenshot A (the first screenshot): Screenshot AScreenshot AIf I click 'No' then I'm taken to a workbook that is completely empty. If I choose 'Yes' I'm given the error in this next screenshot (Screenshot B): Screenshot BScreenshot BClicking 'OK' will take me to a blank workbook as well. 

 

For reference, I am the owner of these reports and have full admin rights to all the workspaces in our organization. Credentials are valid and data refreshes are successful, occurring every 24 hours. I've tried granting myself access to the reports manually through email but even trying to click on the report from my mailbox leads to the same issue.  Other colleagues can access exports of the data but for some reason I cannot. 

 

Any help/insight would be much appreciated. Thank you sincerely.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @ajaramil 

 

What I meant was to first open the Excel desktop application. And then connect to the Power BI Dataset?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

7 REPLIES 7
GilbertQ
Super User
Super User

Hi @ajaramil 

 

What I meant was to first open the Excel desktop application. And then connect to the Power BI Dataset?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ It worked! A simple work-around to a real headscratcher.  Thank you.

Awesome glad you got it working!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @ajaramil 

 

What happens if you connect from the Excel desktop application to the dataset does it then work?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ I'm assuming you're saying to go into my Onedrive file explorer and try opening the workbook from there. Via that route, I'm unfortunately still taken to blank workbooks in the Excel desktop app.

 

GilbertQ
Super User
Super User

Hi @ajaramil 

 

You need to make sure that you have got Build permissions on the underlying dataset.

 

Build permission for shared datasets - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ Thank you so much for your willingness to help out. I checked out Build Permissions and looked into managing what permissions are set for the accounts I have access to: my account and my organization's service account, both of which have the same issue exporting data (the bottom two in Screenshot C ). Both have all permissions granted to them. I also filtered the view by Build permissions to double check, and sure enough both of those accounts appeared. Screenshot CScreenshot C

 

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors