46,250 questions
This is not Power Query I am asking about the MSOLEDB Driver SQL Server Connection which is specified in the connection string of power BI unable to connect to SQL Server Db. Though Driver 19.0.0 is installed on it.
We have installed Microsoft OLEDB Driver SQL Server 19.0.0.0 still we see MSOLEDBSQL is not registered on the local machine
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 49%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Soumya Samprathi
6
Reputation points
Hi we have installed Microsoft OLEDB Driver SQL Server 19.0.0.0 64 bit version and inside power BI desktop we are connecting using connection string MSOLEDBSQL, it works on one server where as when i am trying to open the same Power BI report locally and try to edit the datasource settings we see the error saying that An error happened while reading data from the provider.The MSOLEDBSQL provider is not registered on the local machine. we have installed Power BI desktop 64 bit and also OLEDB Driver for SQL Server 19.0.0.0.64 is also in 64 bit. Not sure what to troubleshoot. Any help will be appreciated.
Community Center | Not monitored
3 answers
Sort by: Most helpful
-
Soumya Samprathi 6 Reputation points
2022-05-11T13:17:00.267+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Ehren (MSFT) 1,781 Reputation points Microsoft Employee2022-05-11T15:57:30.827+00:00 In that case, please pick a more accurate tag. The question is currently tagged as being related to Power Query.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
BJN 6 Reputation points2022-08-25T05:59:05.117+00:00 with the release of the v19 version there are some differences
https://learn.microsoft.com/en-us/sql/connect/oledb/major-version-differences
the driver for the v19 version of Microsoft OLEDB has the version in the name => "MSOLEDBSQL19"
to verify that, open up Powershell and start:
(New-Object System.Data.OleDb.OleDbEnumerator).GetElements() | select SOURCES_NAME, SOURCES_DESCRIPTION
now you see your registered drivers
-
BJN 6 Reputation points
2022-08-25T06:03:10.873+00:00 also, the security default settings changed
if you dont use ssl then disable it with the keyword"Provider=MSOLEDBSQL19; Server=SQL_PROD; Database=PPRD; UID=user; PWD=passwd; ** Use Encryption for Data=Optional;**"
Sign in to comment -
-
Ehren (MSFT) 1,781 Reputation points Microsoft Employee
2022-04-29T18:10:59.643+00:00 Hi there. Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.