Forum Discussion

carlton7372's avatar
carlton7372
Icon for Helper III rankHelper III
2 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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.

carlton7372's avatar
carlton7372
Icon for Helper III rankHelper III
2 years ago

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