Analyze in Excel Download Not Working but Excel Ribbon Does

[asjones]

I wanted to do an Analyze in Excel in Power BI. Under the Data Set I select Analyse in Excel and am prompted to download and .ODC file.  I am prompted to open it in MS Excel (running Firefox). I select to open in Excel I get a blank workbook (not even gridlines) with a yellow bar proompting me to enable editing. I do this and have nothing else. No Pivot Table etc.

I then installed the Powr BI publisher (Ribbon Bar). I signin to Power BI though Excel, connect to my data set and am presenting with options to make a pivot table. 

Why is the first option not working but the 2nd one is? What am I doing wrong?

Prevoiusly i had updated Excel with the Analysize in Excel updates.

thanks for the info and any ideas

Alan

[Icey]

Hi @asjones ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @asjones ,

Please check if your Excel version is Microsoft Excel 2010 SP1 or later. I have tested on my side, Excel 2016, and it works well.

Best Regards,
Icey

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

[asjones]

I sould add I reviwed

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

https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel

https://docs.microsoft.com/en-us/power-bi/publisher-for-excel