Analyze in Excel create an online excel file instead of standard desktop xlsx file

[Jaga]

Hi there, 

Some of my collegues in organisation are not able to create a xlsx excel file while clicking 'analyze in excel'. Power BI is creatig an online file instead with some errors.

I am not sure what changed, as it was possible couple of days/weeks before...

Anyone know what could be the reason?

[v-zhangti]

Hi, @Jaga 

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards

[v-zhangti · Accepted solution]

Hi, @Jaga 

The Analyze in Excel option in Power BI service will download an ODC file (ODC stands for Office Data Connection). ODC file can be opened with Excel.

This file is a data connector which will allow Excel to connect to the Power BI data. You should save this file to an accessible location on your computer.

When you first connect to an ODC file you may be asked to sign into Power BI to authenticate the connection between Power BI and Excel.

You'll then get a security warning. We'll select enable, which opens up a Pivot Table interface you might be familiar with if you've used Excel.

For reference:

https://radacad.com/say-no-to-export-data-yes-to-analyze-in-excel-power-bi-and-excel-can-talk 

https://www.mssqltips.com/sqlservertip/4365/analyzing-power-bi-data-with-excel/ 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel 

Best Regards,

Community Support Team _Charlotte

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

[GilbertQ]

Hi @Jaga 

This was changed and is documented in the link below

Start in Power BI with Analyze in Excel - Power BI | Microsoft Docs

The other way is to open Excel, click on Data Ribbon, then Get Data, From Power Platform, From Power BI