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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors