cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jordi-f
New Member

Power BI deployment pipeline invalid rule when changing data source

We are trying to set up deployment pipelines to deploy our datamodel, that has been created through tabular editor / visual studio tabular project. The deployment through these tools works fine and the dataset refreshes without problems. The data source is an on-premise SQL server database and is reachable through the on-prem gateway.

 

After deploying to the acceptance workspace the first time we tried to change the data sourcer through a rule. This works fine until we hit save. The error is "Invalid rule" without further specification.

 

Because we don't have our model in power bi desktop we cannot work with parameters so it should work through the use of the data source rule. Have tried several suggestions in other topics like using lower case or avoid select * but none resulted in a solution. Also tried to update the dataset in the acceptance workspace after the first deployment to the correct setting and refresh. That works and afterwards we are able to select the data source as "With this" rule but still, any change to the rule results in "Invalid rule"  

 

What should be accomplished is that we can change the datasource from SERVER1/DATABASE to SERVER2/DATABASE.

What to do?

 

Untitled.png 

9 REPLIES 9
Nimrod_Shalit
Power BI Team
Power BI Team

Update- found a bug in that area, and we are actively working to solve it.

I will update here once we know we found the solution and the expected ETA.

 

Anonymous
Not applicable

@Nimrod_Shalit Any updates on this already? Thanks!

Hello,

It would also help us a lot I guess if the error message was more accurate than "Invalid rule". Here I understand that the bug we are having may be on your side. However, before I saw your answer here I really lost hours trying to figure out what was the problem by tuning every possible parameters one by one because I did not know what was wrong.

FJV
Frequent Visitor

It seems to me that setting a deployment rule on a "legacy" connection created in Tabular editor isn't correctly supported. Any workarounds?

Nimrod_Shalit
Power BI Team
Power BI Team

@Anonymous, @Jordi-f@FJV - The best thing would be to open a support ticket, that includes the exact details of what you are trying to do and type of data source you are using.

It's also crucial that you supply Fiddler traces when trying to save the rule, so that we can properly investigate the root cause.

FJV
Frequent Visitor

Any progress on this issue? We are facing the same.

Eyelyn9
Community Support
Community Support

Hi @Jordi-f ,

 

Are you using a parameter for the Database name? If so, a direct data source rule that includes a parameter will not work, please use param rules.

 

Please go into settings of the new App workspace and set up the parameters to the correct one. And refresh the data source with user name and password. 

 

You may refer to this:

Troubleshoot deployment pipelines, the Power BI Application lifecycle management (ALM) tool - Power ...

Solved: Deployment pipelines Parameters Invalid Rule - Microsoft Power BI Community

Solved: Deployment Pipelines - Change datasource - Cannot ... - Microsoft Power BI Community

 

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

Parameters are not a part of analysis services projects so no parameters available...

Anonymous
Not applicable

We're encountering exactly the same problem over here! Any progress on this yet?

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors