Change Source for Azure Data Bricks within Power BI Desktop

[jack_kennedy]

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 connection. The Change Source... option is always greyed out. I am just checking if this is a known limitation or if there is anyway around this as deploying reports through environments is very cumbersome as we have to manually update the connection string for every report for every environment.

Thanks for your help!

[Don-Bot]

It looks like this is still an issue.  However, I got around it by simply inserting my parameters into the M Code myself.  I created parameters (with text) like you normally would.  Then in the M Code in edit query I replaced the current httppath and source with my parameters

[Anonymous]

Was this issue resolved? I am facing the same issue. However with personal access token it seemed to work but we cant use access tokens always

[power_user_123]

I am facing the same issue too. How did it work with personal access token ?

[jack_kennedy]

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!

[v-yangliu-msft]

Hi  @jack_kennedy ,

We can use the created parameters to get data. In Power query, we can get different data from different data sources by changing the current value

For details, you can check the relevant content in the following link:

https://community.powerbi.com/t5/Community-Blog/Why-can-t-I-change-the-Data-Source-in-Power-BI-disab...

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

https://community.powerbi.com/t5/Desktop/Changing-Data-Source/td-p/497753

https://community.powerbi.com/t5/Desktop/How-to-change-data-source-in-Power-BI-desktop-From-CosmosDB...

https://github.com/Microsoft/DataConnectors/issues/69

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.