Power BI

New

DataBricks error-message "Value cannot be null. Parameter name: s" in April 2023 release

Vote (2)

Tim Janssen on 17 Apr 2023 08:37:00

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.

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: