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?
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.
It's also crucial that you supply Fiddler traces when trying to save the rule, so that we can properly investigate the root cause.
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:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!