Forum Discussion
Helper IIIHow to Export Data into Excel with app.powerbi.com
carlton7372 , Hope you are doing that after enable the content. Make sure excel is using same login as power bi.
You can try one more way, Go to the data tab-> use a source as Power BI dataset and try to create a pivot table. Make sure Excel is using the same login as Power BI. If this does not work, then you need to check the tenant setting and enable the XMLA end point.
Hi, carlton7372
May I ask if you have resolved this issue?After testing, this feature works fine.
You can try to solve it according to Ritaf1983 and amitchandak methods. If you still have doubts, you can try the following steps to solve the problem.
1. Check Permissions: Make sure you have the required permissions to export the data. Sometimes, access restrictions may prevent a successful export. Make sure you have the appropriate permissions to perform this action.
2. Clear browser cache: Clear your browser cache and try again. Sometimes cached data can cause unexpected problems. Restart your browser and try the export again.
3. Alternative export method: Instead of using "Analyze in Excel", try the following alternative method:
Go to "app.powerbi.com" and select the report you want to export.
Click the three dot (ellipsis) button in the upper right corner of the selected visual object.
Select Export Data.
Choose whether to download a CSV or XLSX file containing the visual data.
4. Checking Data Model Integrity: The error message you are receiving ("The HTTP server returned the following error: Access Denied") may be related to a problem with the underlying data model. Make sure your data model is set up correctly and that there are no problems. (You can change some data to test, if the other data can be exported normally, then the probability of your data model error is very high)
5. Review Firewall and Network Settings: Sometimes, network or firewall settings can interfere with data export. Verify that the network settings allow communication between Power BI and Excel.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Helper IIIHi Yang,
Are you suggesting that you can export from Power BI desktop? I was under the impression, this could only be achieved from app.powerbi.com
Hi, carlton7372
Power BI desktop only supports exporting to PDF or templates for the time being.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum