Unable to Connect to Databricks with Power BI via DirectQuery

Hello Community,

I am attempting to connect Databricks to Power BI as described in the following link

https://azure.microsoft.com/en-gb/blog/structured-streaming-with-databricks-into-power-bi-cosmos-db/

I have also tried connecting with the standard hostname 'northeurope.azuredatabricks.net', however I keep on getting the following error:

Details: "ODBC: ERROR [HY000] [Microsoft][Hardy] (34) Error from server: Bad Status: HTTP/1.1 303 See Other."

Can someone please help resolve this issue.

Thanks

Carlton 

Hi Anonymous,

Please follow the document Connect Power BI Desktop to a Databricks cluster which introduces the steps in details.

Please check if your server addresss is in right format?

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;