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

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

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:

fz_1-1619711317876.png

then login and shows 2nd error

 

fz_0-1619711220169.png

Can anyone help me? Thanks!

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @fz ,

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:

 

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.

View solution in original post

1 REPLY 1
v-yingjl
Community Support
Community Support

Hi @fz ,

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:

 

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!