The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
22 | |
11 | |
11 | |
10 |
User | Count |
---|---|
111 | |
33 | |
28 | |
21 | |
19 |