Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
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)
InnerException2.Stack Trace:
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()
OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-GB)
CLR Version:
4.8 or later [Release Number = 528372]
Peak Virtual Memory:
70.6 GB
Private Memory:
868 MB
Peak Working Set:
1.2 GB
IE Version:
11.789.19041.0
User ID:
85c7faf5-ba23-4e1d-b70d-14b49005f856
Workbook Package Info:
1* - nl-NL, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
Import
Model Version:
PowerBI_V3
Enabled Preview Features:
PBI_enableWebView2
PQ_WebView2Connector
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_optimizeTabRibbon
PBI_relationshipEditPane
PBI_angularRls
PBI_setLabelOnExportPdf
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_sparklines
PBI_onObject
PBI_dynamicFormatString
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
150%
Supported Services:
Power BI
-------------------------------------------------------------------------
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Whazeboo
If you recreate a report with same data source , same connection mode and same query , can you write it normally in PBI Desktop ?
Best Regards,
Community Support Team _ Ailsa Tao