Analyze in Excel Not Working

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.