Forum Discussion
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:
then login and shows 2nd error
Can anyone help me? Thanks!
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.
1 Reply
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.