Errors with Dataverse and SQL Connector when

[Peter_Schmidt]

Feedback Type:
Frown (Error)

Timestamp:
2022-03-30T04:37:22.3217646Z

Local Time:
2022-03-30T12:37:22.3217646+08:00

Session ID:
c870f120-9bdb-45c1-acfe-d960defe8d53

Release:
April 2022

Product Version:
2.104.301.0 (22.04) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.104.301.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult","MethodDef":"OnException","ErrorOffset":""}

OS Version:
Microsoft Windows NT 10.0.22000.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528449]

Peak Virtual Memory:
54.8 GB

Private Memory:
789 MB

Peak Working Set:
0.987 GB

IE Version:
11.1.22000.0

User ID:
11c68af0-7a55-4474-9789-4bc7f62cae21

Workbook Package Info:
1* - en-AU, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_azureMapVisual
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_useModernFormatPane
PBI_sparklines

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_lineChartError

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
200%

Supported Services:
Power BI

[Nan-Liu]

Hi Peter,

Do you receive any feedback? I cannot connect sql server to power bi as well, I tried two server, one could be connected, another cannot. I don't know if you have same issue.

Thanks

[Peter_Schmidt]

No, and its happening in different dashboards in different tenants. My PC is running the latest version of Win 11 and PBI Desktop. The fact that you are seeing this is well makes me think its a service issue. I'm still getting the same error now...

[Nan-Liu]

I fixed my issue, by uninstall powerbi and install powerbi agian, you could try if it works for you!

Hope that could fix your problem.

[v-cazheng-msft]

Hi @Peter_Schmidt ,

May I know whether you get this issue when connecting to Dataverse and SQL Server data sources? Did you do any operations before you get this issue?

According to the logs from you, it shows that you have enabled PBI_enableWebView2. Could you please try the following step to see whether you still will have problems?

Go to File>Options and Settings>Options>Preview features>Untick Power BI infrastructure update and restart Power BI.

Best Regards,

Community Support Team _ Caiyun

[Peter_Schmidt]

I uninstalled and re-installed PBI Desktop and it seems to be working again now.

In my job I need to swap between tenants as I am logged in to my PC using my MS employee credentials and also using a12mth demo tenant and a business tenant. I'm not sure if this is a factor and the connectors are caching credentials? Anyway I seem to be up and running again now...

[v-cazheng-msft]

Hi @Peter_Schmidt ,

That’s great! Thanks for your reply!

Best Regards,

Community Support Team _ Caiyun