ERROR: PBI Desktop unable to connect to SQL Server. Type Initializer exception

[KEITHO]

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'

[v-chuncz-msft]

@KEITHO 

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.

[KEITHO]

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.