question

soumyaJoshi-3001 avatar image
0 Votes"
soumyaJoshi-3001 asked Ehren commented

We have installed Microsoft OLEDB Driver SQL Server 19.0.0.0 still we see MSOLEDBSQL is not registered on the local machine

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.

power-query-not-supported
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

Ehren avatar image
0 Votes"
Ehren answered

Hi there. Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

soumyaJoshi-3001 avatar image
0 Votes"
soumyaJoshi-3001 answered Ehren commented

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.

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ehren avatar image Ehren ·

In that case, please pick a more accurate tag. The question is currently tagged as being related to Power Query.

0 Votes 0 ·