Forum Discussion
An error happened while reading data from the provider
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.
3 Replies
- amitchandak
Super User
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
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.
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.
