An error happened while reading data from the provider

[Saurabh_Naik]

 

I faced erroe while connecting to Sql server from Power BI. I faced error as below:

"An error happed while reading data from the provider: the type initializer for microsoft.data.sqlclient.sninativemethodwrapper threw an exception"

I recently updated SSMS and reboot it. Please assist me to resolve this issue as soon as possible.

[hrauch_]

Are there actual instructions to get around this somewhere? The git threads copy/pasted here by @amitchandak  are just conversations with no clear solution which is more confusing than helpful.

[cjpcman01]

I am having the same issue with all SQL connections since the Nov 2020 update, I did uninstall and relaod OCT 2020 version and the refresh works no problem, but since the files was saved under NOV 2020 and the model was "upgraded" i get many more errors, also can see the model view in OCT 2020 or save keep getting crash/unknown errors.

[amitchandak]

@Saurabh_Naik , refer these two, if they can help

https://github.com/dotnet/SqlClient/issues/468

https://github.com/dotnet/SqlClient/issues/361

or log an issue : https://community.powerbi.com/t5/Issues/idb-p/Issues