ERROR: PBI Desktop unable to connect to SQL Server. Type Initializer exception
PBI Desktop, manual download not appstore. Latest version. End of message for details
Post download of latest version, i opened a previous desktop report, brought in another data source from SQL server (2016), and published without any issues.
Then i opened a new PBI desktop window to make a new report, and since then i am getting this error message for all reports when i try to get source data.
Version:
2.87.923.0 64-bit (November 2020)
Feedback Type:
Frown (Error)
Timestamp:
2020-11-27T13:22:46.2546927Z
Local Time:
2020-11-27T13:22:46.2546927+00:00
Session ID:
a10bb697-7dbb-4cfc-b31c-3c3e7c00c694
Release:
November 2020
Product Version:
2.87.923.0 (20.11) (x64)
OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528040]
Workbook Package Info:
1* - en-IE, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
Empty
Model Version:
PowerBI_V1
Is Report V3 Models Enabled:
True
Enabled Preview Features:
PBI_v3ModelsPreview
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
'microsoft.data.sqlclient.sninativemethodwrapper' threw an exception'
2 Comments
- v-chuncz-msft
Community Support
I tried the latest version (2.87.923.0) but cannot reproduce the issue. You may try earlier versions from Previous monthly updates to Power BI Desktop and create a support ticket for assistance if necessary.
- KEITHOFrequent Visitor
Thanks.
I installed October version and this has resolved the issue.
There must have been inadequate testing on the November release and issues remain on the November release. Issues with latest releases is becoming a very common occurrence.