Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AdityaS
Frequent Visitor

Analyze in Excel - Refresh Error

Hello,

 

I have developed 'Analyze in excel' report that is connected to a report published on Power BI Service. 

I have shared the file with users so they can refresh the report on their end and get the latest data.

The Power BI report refreshes daily.

 

Some users get the following error. It is very irregular and they get it either while refreshing the Analyze in excel file or sometimes while just selecting a particular filter, etc. Sometimes they may not even get the error and are able to refresh the report without any issue.

 

Anybody know why I get this error ?

 

DatabaseDriverIssue_PowerBI.JPG

 
 

 

 

Thank you,

Aditya Sardeshpande

 

1 ACCEPTED SOLUTION

Hi @AdityaS 

 

First, please log into Power BI with the account that has permission.

 

Then, please check if you meet these requirements:

  • 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. To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing.

  • Users can connect to datasets through Analyze in Excel if they have read permission on the underlying dataset. A user could have this in several ways, such as being a member of the workspace containing the dataset, having a report or dashboard shared to them that uses the dataset, or having permission to an app that contains the dataset.

  • The Analyze in Excel is a Power BI service feature, and is not available in Power BI Report Server or Power BI Embedded.

  • Analyze in Excel is only supported on machines running Microsoft Windows.

 

For more details, you can refer to these documents:

https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel#forbidden-error;

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#requirements.

 

Community Support Team _ Dina Ye
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

3 REPLIES 3
v-diye-msft
Community Support
Community Support

Hi @AdityaS  

 

Could you please specify more details?(e.g. data source type, connection mode, operations steps...)

 

There may be times when using Analyze in Excel that you get an unexpected result, or the feature doesn't work as you expected. This page provides solutions for common issues when using Analyze in Excel

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

 Data Source - Teradata \ Connection Mode - Import

 

I do perform simple power query/operational steps to get the data in the format I need for reporting and also add some calculated fields.

 

Thank you.

 

Hi @AdityaS 

 

First, please log into Power BI with the account that has permission.

 

Then, please check if you meet these requirements:

  • 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. To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing.

  • Users can connect to datasets through Analyze in Excel if they have read permission on the underlying dataset. A user could have this in several ways, such as being a member of the workspace containing the dataset, having a report or dashboard shared to them that uses the dataset, or having permission to an app that contains the dataset.

  • The Analyze in Excel is a Power BI service feature, and is not available in Power BI Report Server or Power BI Embedded.

  • Analyze in Excel is only supported on machines running Microsoft Windows.

 

For more details, you can refer to these documents:

https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-analyze-in-excel#forbidden-error;

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel#requirements.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors