Error connecting to Azure Analysis Services - (file 'pfadalauthinfo.cpp', function PFAdalAuthInfoConfigurationWrapper::GetInstance')
We use two-factor authentication (2fa/mfa) to connect to the Azure Analysis Services (AAS / SSAS). Recently, some users have been getting this error message in their Excel 2019
file 'pfadalauthinfo.cpp', function PFAdalAuthInfoConfigurationWrapper::GetInstance'
They have an Excel file connected to the cube. Usually they just click refresh and the prompt opens up to login via 2fa (Okta), like in image below. Instead they receive the pfadalauthinfo.cpp error (the login prompt doesn't even appear)
They are on Office 2019 (Version 1808 (Build 10382.20010)) and Windows 10. These users have been able to connect in the past but no longer. In some cases, they previously connected on their laptop but can't connect after receiving a new laptop.
For one user, we attempted to overwrite the drivers (per these articles (1, 2) but that didn't work. We discovered if we switch them Office 365, it connects perfectly. We can't do this for every user and Office 2019 should work. This seems like a bug in Office or the driver. Any workarounds?
We worked with Microsoft support directly and they found an issue with the client libraries, namely the MSOLAP. New versions were posted to the site:
https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions
We tested and all is well now.
- Scoring values including NA() - Excel 365
- Getting the actual usedrange
- Extract non-contiguous data from multiple sheets while extracting from a list with a loop
- Excel VBA - Skip renaming when cell empty
- Protected Cell warning when returning to original cell after DoubleClick
- how to automatically color the lines for each different word, to make it easier to see the difference
- Java Poi XSSF - create pivot table with multiple expandable columns
- Import Excel to Pandas Dataframe, but preserve order of Day/Month in dates?
- Pass an array to a function from a multidimensional array
- VBA Characters.Delete string over 255 characters
- Conditional Formatting Help - Compare Concat cells and Format Range/Table by row based on matches
- problem with VBA code for vlookup from a few different workbooks
- Partial value font color in red using vba
- VBA to manually position an Excel pivot when AutoSort is blocked
- VBA loop through multi-d array and keep values that meet criteria in one column
- Count the value of the current stock in excel
- Extract time from a date time string in excel
- Easy way to export multiple data.frame to multiple Excel worksheets
- Is it possible for HYPERLINK to spill friendly names?
- Loop inside loop. Stop second loop if condition is met
- Using TEXTJOIN to display table values of numbers within certain criteria
- Add attachement to email with VBA
- How to Save DataFrame to Excel file using filedialog as SaveAs-Dialog in Python?
- Excel MS365: 2-D dynamic array creation problem
- Search the latest saved PDF file in a various folders and copy the latest one to a specific location
- How do I get all the different unique combinations of 3 columns using VBA in Excel?
- Worksheet names in VBE
- Excel macro to identify 0 crossing of the value
- Format Multienumeration Data for Pivot Table
- Using Excel, return 1 for all values >0 WITHOUT using an IF