Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

How to change data source in deployment pipeline we are using databricks as Datasource

We are trying to use the deployement pipeline in power bi services, however we have three different URLs for different environment. Once we deploy PowerBI report from Dev to Test/QA the datasource details has to change with deployment(Databricks details).
Data source rules is disabled in add rules option.
Unable to refresh the datasource with Parameters in Databricks(is it supported) I have an idea how to implement in SQL DB.  

Thanks in advance for your response. 

Power BI Team
Power BI Team

Regarding deployment rules:

1. you have to be the dataset owner to configure rules. That why it might be disabled for you.

2. there no option to set rules directly on databricks as a data source. you will need to parameterize the URL connection string on the dataset itself, and then use rules to change the parameter value for that dataset.

Hi I'm the owner of the dataset. Still not getting data source rules option.
Parameters are enabled but unable to give those parameters as Server name and HTTP path in data source settings in Power BI Desktop. As Change source is disabled.
We are using DataBricks as Data Source.



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors