cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
t_sri_sam Frequent Visitor
Frequent Visitor

Analyze in Excel doesn't work

Analyze in Excel has downloaded an odc file. When I tried opening, it throws the following error in excel.

analyzeinexcel.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Analyze in Excel doesn't work

Hi @t_sri_sam ,

 

There are several points you may considerate:

 

1.You need some Excel Updates, you can see the page below when you click the "Analyze in Excel" button.

 

53.png

 

 

2.Currenlt, the "Analyze in Excel" feature may require both options(Export data and Analyze in Excel) to be enabled in Admin Portal.

 

3.There are a few requirements for using Analyze in Excel, see more limitation Analyze in Excel :

  • Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.
  • Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures.
  • Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel. If you’re unable to install the updates, check with your administrator.
  • Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license.
  • Users can connect to datasets through Analyze in Excel if they have read permission on the underlying dataset. 

 

You may resolve the issue via the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel.

 

If you encounter a scenario that is not listed below, and it is causing you issues, you can ask for further assistance on the community site, or you can create a support ticket.

 

Best Regards,

Amy

 

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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Analyze in Excel doesn't work

Hi @t_sri_sam ,

 

There are several points you may considerate:

 

1.You need some Excel Updates, you can see the page below when you click the "Analyze in Excel" button.

 

53.png

 

 

2.Currenlt, the "Analyze in Excel" feature may require both options(Export data and Analyze in Excel) to be enabled in Admin Portal.

 

3.There are a few requirements for using Analyze in Excel, see more limitation Analyze in Excel :

  • Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.
  • Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures.
  • Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel. If you’re unable to install the updates, check with your administrator.
  • Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license.
  • Users can connect to datasets through Analyze in Excel if they have read permission on the underlying dataset. 

 

You may resolve the issue via the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel.

 

If you encounter a scenario that is not listed below, and it is causing you issues, you can ask for further assistance on the community site, or you can create a support ticket.

 

Best Regards,

Amy

 

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

View solution in original post

Community Support Team
Community Support Team

Re: Analyze in Excel doesn't work

Hi  @t_sri_sam ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors