01-03-2019 04:48 PM
I have a PowerQuery which I have successfully imported to PowerBI. When I click to refresh data I get the error "An error happened while reading data from the provider: 'The MSOLAP.8 provider is not registered on the local machine."
I went into Excel and checked the data connection string being used to connect to the SSAS cube the Power Query is connected to and it's MSOLAP.8
I also went into registry and it also shows MSOLAP.8
If anybody knows how to fix this is would be GREATLY appreciated!
01-04-2019 05:00 AM
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
01-10-2019 12:55 PM
Figured out the solution. Installing the client libraries for connecting to Azure Analysis Services. I didn't have any 32 vs 64 bit conflicts, and MSOLAP.8 was already in my registry. Dowloading the MSOLAP (amd64) libraries at this link did the trick.