Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This only happens in the NOV 2020 Verison of PowerBI Desktop,
An error happened while reading data from the provider: 'The type initializer for 'Microsoft.Data.SqlClient.SNINativeMethodWrapper' threw an exception.'
When I try to refresh from PBID or connect via PowerQuery this error shows.
I have opened the file in OCT 2020 version of PBID and connections work, just get lots of other general errors and the DataModel does not load since I clicked the Upgrade button in the Nov2020 version.
Only found this when I tried to edit some of the model queries. Since the update I published and ran the refresh from the service and no problems, only seems to be within PowerBI Desktop and PowerQuery
The only other wierd item I noticed was that my PowerQuery folder structure all exploded and was not active, many of the Helper Files (from reading files in folders generated by powerquery) started to load in the model and were not before, had to manually unload from model.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.