Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

'DataBricks' Import-query not working since April 2023 release

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

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

 

Status: Needs Info

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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

Whazeboo
New Member

Hello @v-yetao1-msft,

I cannot write any DataBricks-query in Power BI desktop since release 2.116.966.0 64-bit (april 2023).

The errormessage pops up as soon as I click the 'OK'-button in the Azure Databricks window (see picture below).

Errormessage April releaseErrormessage April release

Lucky enough I also have release 2.112.1421.0 64-bit (januari 2023) installed. Using the same credentials and code returns data (see picture below).

OK results January 2023 releaseOK results January 2023 release

 

Anyway, can it be a bug regarding DataBricks is accidentally introduced in the April 2023 release?