The provider Microsoft.PowerBI.OleDb is not registred

[Anonymous]

Hello,

I am executing a SQL Script in SQL server Management Studio and it works fine! No error at all.

In Power BI, I select Get Data, then SQL server.  After that, I enter the server name, the database, and the script.

Power Bi import the data but I received the above mentioned error message.

Does someone know how to solve that issue.

[EMIDH]

I use my company's 365 subscription and had a PowerBI table connected to Google Cloud. The error came when trying to refresh the data. After uninstall and install of latest version, the error has dissapeared. 

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

After my researching, you could uninstall and reinstall Power BI Desktop.

These are the relevant cases:

https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-not-connecting-to-Access-on-64-bit/m-p/145070

https://community.powerbi.com/t5/Desktop/Trying-to-enter-2x2-table-manually-and-getting-the-Microsoft/m-p/706787

[omikeyz]

I had Office 365 installed and then came across this error, I uninstalled and re-installed and MS Access table loaded without any errors. Thank you!