Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
dinesh123
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. 

3 REPLIES 3
shwet
Frequent Visitor

Hi

 

I am also facing similar issue with the Parameter rules. I am the admin of Deployment pipeline, workspace and owner of the dataset still i am seeing "add rule" option is greyed out for me. Would really appreciate if someone can help

shwet_0-1701947701067.pngshwet_1-1701947786899.png

Nimrod_Shalit
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.

dinesh123_0-1679572285902.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors