Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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): If 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): Clicking '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.
Solved! Go to Solution.
Hi @ajaramil
What I meant was to first open the Excel desktop application. And then connect to the Power BI Dataset?
Hi @ajaramil
What I meant was to first open the Excel desktop application. And then connect to the Power BI Dataset?
Awesome glad you got it working!
Hi @ajaramil
What happens if you connect from the Excel desktop application to the dataset does it then work?
@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.
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
@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.
User | Count |
---|---|
24 | |
21 | |
11 | |
11 | |
10 |
User | Count |
---|---|
50 | |
31 | |
20 | |
18 | |
15 |