Forum Discussion

AdityaS's avatar
AdityaS
Frequent Visitor
6 years ago
Solved

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 ?

 

 
 

 

 

Thank you,

Aditya Sardeshpande

 

Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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.

     

3 Replies

    • AdityaS's avatar
      AdityaS
      Frequent Visitor
      6 years ago

       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.

       

      • v-diye-msft's avatar
        v-diye-msft
        Community Support
        6 years ago

        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.