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.