When I try that I get the following error message:
Selected user account does not exist in tenant 'Microsoft' and cannot access the application.
'https://pbiwiki.com/simplesaml/www/module.php/saml/sp/metadata.php/default-sp' in that tenant. The account needs to be added as an external user in the tenant first. Please use a different account.
Try the following workaround:
2. Close all office applications
3. Go to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 and rename the adal.dll to adal_orig.dll (if you have excel 64 bit use the version from Program Files / ProgramFilesX64)
4. Copy the adal.dll from here: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130 to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 (if you have excel 64 bit use the version from Program Files / ProgramFilesX64)
5. Open the odc file and see if it works for you
At any point you can go back to the original adal file.
That didn't work. Possibly because the AS OLEDB version is only 110 on my system.
C:\Program Files\Microsoft Office 15\root\vfs\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\110
Installation step works for me
You are a genius. Kudos.
You can not understand how much you've helped me. @jllelis
Actually, I am a good user of Excel for some time. I like to use queries and data relationships to calculate profit on foreign exchange mega data. It happened that my Excel Office 2016 was uninstalled by the IT department after a year of activity. Another IT staff came and installed Office 2016 Professional Plus and I was happy to get back to my data and peform my calculations as usual.
The first query I refreshed couldn't. I thought it was a rather complex query. I started simple queries from simple tables but neither could load. I asked Microsoft, by default, they said, this is due to "Old PowerPivot Add-Ins" to put it simple. I went on many forums, tried almost every proposed solution:
-Removing & Replacing Add-Ins
-Running latest office updates
I tried numerous options and none seemed to be proper.
When I tried @jllelis option to install "Microsoft AS OLE DB Provider for SQL Server 2016" available here and it worked flawlessly and all my data refreshe and loaded perfectly.
Thank you @jllelis
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.