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
carlton7372
Helper I
Helper I

How to Export Data into Excel with app.powerbi.com

Hello Community,

 

Each time I select 'Analyze in Excel' I get the message 'Failed to open file in Excel ..... so the file has been dowloaded to your computer'. 

My attempts to open the downloaded excel file fails.

 

I first get the error screen 

carlton7372_0-1709584981308.png

 

Followed by the following error

 

carlton7372_1-1709585014926.png

 

Any thoughts on any other approaches to export the data in Power BI?

 

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

6 REPLIES 6
v-yaningy-msft
Community Support
Community Support

Hi, @carlton7372 

May I ask if you have resolved this issue?After testing, this feature works fine.

vyaningymsft_2-1709619221627.png

 

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.

vyaningymsft_0-1709619150510.png

 

vyaningymsft_1-1709619178165.png

 


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

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

vyaningymsft_0-1709687754286.png

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

Ritaf1983
Super User
Super User

Hi @carlton7372 
There can be many causes of this error.
Please refer to the linked documentation about troubleshooting :

https://learn.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-exce...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

amitchandak
Super User
Super User

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

Thank you. This was the problem. The account used with Excel was different to that used with app.powerbi.com. That being said, I still couldn't analyze straight from app.powerbi.com. I had to download first and then open with Excel. But that is fine. 

 

Thank you

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.