Forum Discussion

jack_kennedy's avatar
jack_kennedy
Frequent Visitor
5 years ago

Change Source for Azure Data Bricks within Power BI Desktop

Hi,   I am currently pulling data into Power BI from my Azure Data Bricks Cluster using the Azure DataBricks connector from the Power BI Desktop.   However I can't seem to paramertise the connect...
Need Help
jack_kennedy's avatar
jack_kennedy
Frequent Visitor
5 years ago

Hi,

 

High. Thanks for taking the time to reply - however I still cannot get this to work. I have set up a Parameter called ADBConnection and set its value to "adb-XXXXXXXXXXXXXX.XX.azuredatabricks.net", "sql/protocolv1/o/XXXXXXXXXXXXX/XXXXXX-XXXXXXXXX-XXXXXX"

 

Then in Power Query I have the following to set the connection string:

 

let
Source = Databricks.Contents(ADBConnection, [Database=null, BatchSize=null]),

 

However I keep getting the error below:

 

Any help appreciated. Thanks!