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.