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.
Hello!
I am encountering problems when trying to connect Power BI to an OLE DB.
The error message says:
Unable to connect
We encountered an error while trying to connect.
Details: "An error happened while reading data from the provider: 'The 'MSOLAP.8' provider is not registered on the local machine.'"
Connection string:
provider=MSOLAP.8;initial catalog=Power_BI_DB;data source="http://127.0.0.1:80/xmla/database=demo_sales";update isolation level=2
(I've also tried "MSOLAP" instead of specific versions.)
The connection string is supposed to be correct because I've tested it on Excel data connections and worked just fine.
Has anyone had this issue recently or is anyone able to identify the problem?
Thank you very much in advance
Hi @JonasH,
Could you go to check if you're using the same version(32-bit or 64-bit) of Power BI Desktop and the MSOLAP provider? If not, could you try using the same version to see if it works?
Regards
Hello!
I'm encountering problems when trying to connect to an OLE data base.
The following error message occurs:
Unable to connect
We encountered an error while trying to connect.
Details: "An error happened while reading data from the provider: 'The 'MSOLAP.8' provider is not registered on the local machine.'"
My connection string is supposed to be correct because I've verified on an Excel data connection and it worked just fine.
The connection string is: provider=MSOLAP.8;initial catalog=Power_BI_DB;data source="http://127.0.0.1:80/xmla/database=demo_sales";update isolation level=2
(I've also tried "MSOLAP" instead of a specific version)
Has anyone had this issue recently or is anyone able to identify the problem?
Thank you in advance!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.