Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

SimonNoer

Analize in Excel Internal Error

Submitted by on ‎01-21-2022 02:25 AM

I'm getting this error
Internal error: An unexpected error occurred (file ' pfadalwrapper.cpp, line 986, function 'PFAdalWrapper::GetInstance').
Excel is 2016 64bit with MDOLAB.5
Every step from Troubleshoot connecting Excel to Power BI data has been tried

 

SimonNoer_0-1642759972801.png

 

Status: Investigating

Hi @SimonNoer 

 

May I know whether you have installed Analyze in Excel updates and open the workbook that generated by Power BI with it? There are some requirements and limitations on using Analyze in Excel, please check whether there is any item causing this issue firstly.

  • Analyzing Power BI data in Excel is supported for Microsoft Excel 2010 SP1 and later.
  • Excel PivotTables don't support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures.
  • Analyzing Power BI data in Excel requires that the dataset be in a Power BI Premium workspace or that you have a Power BI Pro or Premium Per User (PPU) license.
  • You can connect to Power BI datasets in Excel if you have permission for the underlying dataset. You could have this permission in a few ways. You could have the Member role in the workspace containing the dataset, or have Build permission for a dataset in a workspace, or in an app that contains the dataset.
  • You can only analyze Power BI data in Excel on computers running Microsoft Windows.
  • Only Power BI datasets that use Import mode will preserve hierarchies in Analyze in Excel workbooks. Power BI datasets built on DirectQuery or composite models will not have their hierarchies retained when using Analyze in Excel.
  • You may see an error message if the data is larger than 2 GB. In that case, either reduce the amount of data, for example by applying filters, or use the XMLA endpoint. Learn more about the XMLA endpoint.
  • Guest users can't analyze Power BI data in Excel for datasets sent from (originating from) another tenant.
  • Analyzing Power BI data in Excel is a Power BI service feature. You can't analyze Power BI data in Excel from Power BI Report Server or Power BI Embedded

For more details, please refer to Connect Excel to Power BI datasets - Power BI | Microsoft Docs and Start in Power BI with Analyze in Excel - Power BI | Microsoft Docs.

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
12 Comments (12 New)
Comments
jhernandeze
Regular Visitor
‎02-22-2022 01:53 AM

Hi All,

 

I managed to solve the problem!!!

 

I have checked the version of the DLL containing the failing function, which is located in this file:

"C:\Program Files\Microsoft Analysis Services\AS OLEDB\140\adal.dll"

 

I had a version 3.1.7, and I replaced the file with another with version 3.3.0 and everything worked.

To see the version of the file, in properties, details tab.

 

Adal.DLL - version.png

 

Luck!

rjgillin13
Frequent Visitor
‎02-24-2022 02:34 PM

Yes, I am having the same issue. I used to be abel to use Analyze in Excel just fine until recently and am running into the same error message as everyone else.

Idea Statuses