Error Message: Object reference not set to an instance of an object

[jogden]

I had a dataset working fine then we made some changes to the SQL Server schema and tried to refresh but I get two errors 

1.) "Error Message: Object reference not set to an instance of an object"

2.) "Error Message: A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread."

here is partial log. Please help!

Feedback Type:
Frown (Error)

Error Message:
Object reference not set to an instance of an object.

Stack Trace:
System.NullReferenceException
at Microsoft.PowerBI.Client.Windows.AnalysisServices.QueryEvaluator.LoadToModelQueryEvaluator.<>c.<EvaluateRelationships>b__26_0(ExtendedLoadToModelQueryEvaluationOutput o)
at System.Linq.Enumerable.All[TSource](IEnumerable`1 source, Func`2 predicate)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.QueryEvaluator.LoadToModelQueryEvaluator.EvaluateRelationships(Report report, Dictionary`2 queryNameToRelationshipInfoContainer, Dictionary`2 queryNameToEvaluationOutput)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.QueryEvaluator.LoadToModelQueryEvaluator.GetEvaluationResults()
at Microsoft.PowerBI.Client.Windows.AnalysisServices.LoadToModelQueryEvaluationService.<EvaluateForLoadAsync>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass8_0`1.<<RunInAsyncActivity>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---

....more

[jogden]

looks like if i revert to prior desktop version the error does not occur with the same file. seems like a problem with the newest April 2022 versions. thats a big problem because this error is totally ambiguous

March 2022 Update (2.103.661.0)

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-de...

[v-cazheng-msft]

Hi @jogden ,

It’s a known issue(ICM 268045992,269223634, 269038329, 271221036, 269096466) caused by WebView2 enabled. Please try these workarounds.

1 Disable WebView2 by unticking Power BI infrastructure update in Files>Options and Settings>Options>Preview feature

2 Ensure the webview2 is latest by installing windows updates and Webview2 update: https://developer.microsoft.com/en-us/microsoft-edge/webview2/

3 Run setx PQ_ExtendEdgeChromiumOAuthDenyList SharePoint;Web on the command line and restart Power BI Desktop

Best Regards,

Community Support Team _ Caiyun