Analyze in Excel Not Working

[Anonymous]

When using Power BI and selecting "analyze in excel" my file downloads as an "odc" instead of excel, despite me downloading all the necessary software.  My team members are having the same problem and cannot run our necessary reports.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

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:

Say No to Export Data, Yes to Analyze in Excel: Power BI and Excel Can Talk!

Analyzing Power BI data with Excel

Best Regards,
Community Support Team _ Zeon Zheng

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

[GilbertQ]

Hi @Anonymous 

You can then click on the ODC and it should open in Excel and connect to the dataset?