Analyze in Excel Download Not Working but Excel Ribbon Does

Question

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

asjones · Answer

I sould add I reviwed&nbsp;https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel&nbsp;https://docs.microsoft.com/en-us/power-bi/publisher-for-excel&nbsp;&nbsp;

icey · Answer

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

&nbsp;
&nbsp;
Best Regards,IceyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

icey · Answer

Hi&nbsp;asjones ,
&nbsp;
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.
&nbsp;
Best RegardsIcey

Forum Discussion

Analyze in Excel Download Not Working but Excel Ribbon Does

3 Replies

Related content

Download pbix from semantic model no longer downloads linked report

Best Practice Analyzer

Download PBIDesktopRS_x64_2.109.801.0

Download cypher results

Download Lakehouse Files