Forum Discussion
Unable to Connect to Databricks with Power BI via DirectQuery
- 7 years ago
Hi Anonymous,
It seems that the error is caused by the URL.
Do you have a try with another format of URL bases on the document?
Best Regards,
Cherry
I have a similar issue, but the error message a slightly different:
I have carefully followed the instructions for extracting the URL. I have also tried the aliased URL as suggested, with no luck.
I have tried both DirectQuery and Import mode, with no luck.
My Databricks DB contains 4 tables, some of them are managed tables and some are not. Also, some tables are Delta tables and some are not.
After pressing Retry, I get a new error:
Here is an exerpt from the detailed error log, which is obtained from "Copy details":
...
Release:
November 2018
Product Version:
2.64.5285.741 (18.11) (x64)
Error Message:
Object reference not set to an instance of an object.
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Object reference not set to an instance of an object. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Object reference not set to an instance of an object. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Object reference not set to an instance of an object. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Object reference not set to an instance of an object. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Mashup.Evaluator.ChannelMessenger.CreateChannel()
at Microsoft.Mashup.EngineHost.Services.RemoteLibraryServiceFactory.Proxy.GetResourceString(String moduleName, String cultureName, String stringName)
at Microsoft.Mashup.Engine1.Library.Extensibility.ExtensibilityModule.LoadStringFunctionValue.TypedInvoke(TextValue stringId)
at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue1`2.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
...
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
...
OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-GB)
CLR Version:
4.7 or later [Release Number = 461808]
Peak Virtual Memory:
37.9 GB
Private Memory:
320 MB
Peak Working Set:
487 MB
IE Version:
11.407.17134.0
Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
Empty
Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared Query1 = let
Source = AzureSpark.Tables("https://westeurope.azuredatabricks.net:443/sql/protocolv1/o/XXX_XXX/xxx-xxx-xxx")
in
Source;
In my case, the problem was that I was using the wrong connector (Azure / Azure HDInsight Spark). The correct connector is Other / Spark.