Forum Discussion
Deployment pipelines Parameters Invalid Rule
I have figured out the issue. Before you set up the rule, you need to go to the data set settings in your new App workspace. there you can ensure the correct parameters are in place and you have signed into the data source.
I have created these in desktop
And I have 3 sql databases on the server as a test
I have changed the database parameter in desktop. the last one wasnt working because of the table name. This is now resolved.
Back in the Pipeline...
No still saying invalid rule to both. I cant see any issues at all so Im currently very stuck. Am I doing something wrong?
Exactly the same issue when I try it as a data source rule.
The data source is an Azure SQL database.
So I cant do either at the moment.
I have figured out the issue. Before you set up the rule, you need to go to the data set settings in your new App workspace. there you can ensure the correct parameters are in place and you have signed into the data source.
Hi Debbie,
I am facing the similar issue with the dataflows, Can you provide me the detail steps on how did you resolved it?
Thanks,
Arsene
Hi there,
i think its changed a fair bit since I last did this "
regarding data source rules- this can't work if you already parameterized the server and DB,
it can only work with parameters now"
basically I dont set the parameters in the Pbix file at all. I always use data flows because Im in Premium and simply connect the pbix to the dataflow thats set up. then in test and Prod its easy to set up the dataflow to use the correct data source in deployment Pipelines.
So fot this one, I never parameterise in the pbix file
got it. even i'm doing the same. i am trying to parameterise in the dataflow and connect the pbix to the dataflow. later i deployed it to Test workspace but when i try to change the parameter value (under dataflow parameter rule) in the deployment pipeline for test workspace, it is showing invalid rule error.
