Error: pivot table, cube function or filter control using the connection 'pbiazure://api.powerbi.com

[Anonymous]

When I use Analyze in Excel function, I open the excel and pop up errors: system failure (translated in english)

after that I logged in with my account and another error shows:
A pivot table, cube function or filter control using the connection 'pbiazure://api.powerbi.com 3ba15e79-xxxxxxxxxxx Model' didn't refresh.

first error:

then login and shows 2nd error

Can anyone help me? Thanks!

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Consider these requirements about using Analyze in excel first:

• 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. Read about creating 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 permission for the underlying dataset. A user could have this permission in a few ways, such as having the Member role in the workspace containing the dataset, or having Build permission for a dataset in a workspace or in an app that contains the dataset. Read more about Build permission for datasets.
• Guest users can't use Analyze in Excel for datasets sent from (originating from) another tenant.
• Analyze in Excel is a Power BI service feature, and isn't available in Power BI Report Server or Power BI Embedded.
• Analyze in Excel is only supported on computers running Microsoft Windows.

To use Analyze in Excel, your computer must have a current AS OLE DB provider installed. 

The Excel libraries need to match your version of Windows in terms of its bit-level. If you have 64-bit Windows installed, you need to install the 64-bit OLE DB provider.

You can also refer:

• KB2847735 - FIX: "A PivotTable, cube function or slicer using connection <conn> had failed to refresh" error  
• Troubleshooting Analyze in Excel 

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