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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors