'DataBricks' Import-query not working since April ...

Whazeboo · ‎04-17-2023

I used to be able to write a Power BI Desktop query using connection 'Azure DataBricks' in data Connectivity mode 'Import'.

However since the April 2023 release it cannot run queries anymore once they are edited or created from scratch. Power BI then returns error-message "Value cannot be null. Parameter name: s". Existing 'Azure DataBricks' queries that are not modified however run fine.

Any ideas how to resolve this?

For sake of completeness this is the error message-log:

-------------------------------------------------------------------------

Feedback Type:

Frown (Error)

Timestamp:

2023-04-17T08:26:10.4904756Z

Local Time:

2023-04-17T10:26:10.4904756+02:00

Session ID:

a5f6aa66-247d-4aff-8c28-3e9971ebe893

Release:

April 2023

Product Version:

2.116.622.0 (23.04) (x64)

Stack Trace:

Microsoft.Mashup.Host.Document.JavaScriptException

at ModernButtonViewModel.prototype.onClick (ms-pbi://pbi.microsoft.com/ts/Shared/Form/ModernButtonViewModel.js:38:9)

at click (Function code:2:31)

at click (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:190:46)

at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:27:21)

at n.event.dispatch (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:7481)

at r.handle (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:5547)

Microsoft.Mashup.Client.UI.Shared.JavaScriptInvocationException

at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)

at Microsoft.Mashup.Client.UI.Shared.Models.ModernButton.OnClick(String parameters)

at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Builders.PhtBuilderHtmlControl.OnButtonClick(String buttonGroupName, String buttonName)

Microsoft.Mashup.Host.Document.JavaScriptException

at MvvmBuilderHtmlControl.prototype._tryCommitChanges (ms-pbi://pbi.microsoft.com/ts/Controls/Builders/MvvmBuilderHtmlControl.js:131:17)

at MvvmBuilderHtmlControl.prototype._onCommitValidCallback (ms-pbi://pbi.microsoft.com/ts/Controls/Builders/MvvmBuilderHtmlControl.js:120:17)

at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28458)

at i (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:27146)

at j.add (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:27263)

at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28439)

at each (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:2856)

at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28385)

at Deferred (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28720)

at d.then (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28355)

System.ArgumentNullException

at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.ITinyEngine.EscapeString(String s)

at Microsoft.Mashup.Host.Document.Formulas.GenericSourceInvokeFormula.OnGetFormulaText()

at Microsoft.Mashup.Host.Document.Formula.get_FormulaText()

at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Builders.MvvmBuilderHtmlControl.CommitChangesToPackage()

at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Builders.MvvmBuilderHtmlControl.TryCommitChanges()

PowerBINonFatalError:

{"AppName":"PBIDesktop","AppVersion":"2.116.622.0","ModuleName":"Microsoft.MashupEngine.dll","Component":"Microsoft.Mashup.Engine1.Engine","Error":"System.ArgumentNullException","MethodDef":"Microsoft.Mashup.Engine.Interface.ITinyEngine.EscapeString","ErrorOffset":"13"}

InnerException0.Stack Trace:

at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)

at Microsoft.Mashup.Client.UI.Shared.Models.ModernButton.OnClick(String parameters)

at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Builders.PhtBuilderHtmlControl.OnButtonClick(String buttonGroupName, String buttonName)

InnerException1.Stack Trace: