Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.