cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Analyze in Excel Download Not Working but Excel Ribbon Does

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

 

 

3 REPLIES 3
Highlighted
Helper II
Helper II
Highlighted
Community Support
Community Support

Re: Analyze in Excel Download Not Working but Excel Ribbon Does

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.

 

analyze.PNG

analyze2.PNG

 

 

Best Regards,
Icey

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

Highlighted
Community Support
Community Support

Re: Analyze in Excel Download Not Working but Excel Ribbon Does

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

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors