Admin/owner unable to view exported data for reports

[Anonymous]

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

[GilbertQ · Accepted solution]

Hi @Anonymous 

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

[Anonymous]

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

[GilbertQ]

Awesome glad you got it working!

[GilbertQ]

Hi @Anonymous 

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

[Anonymous]

@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]

Hi @Anonymous 

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

Build permission for shared datasets - Power BI | Microsoft Learn

[Anonymous]

@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 C