I have parameters set for my server and database for my data source Im attempting to change to my test database I know that this is correct and I have made sure I can log in to the data source in Service. All the credentials are OK. I cant work out why its saying Invalid Rule. Any help would be appreciated. the same thing happens when you do it through creating a database 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.

Deployment pipelines Parameters Invalid Rule

10 Replies

v-lili6-msft
Community Support
6 years ago
hi DebbieE

you may refer to this document:

https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-troubleshooting#why-did-my-deployment-fail-due-to-broken-rules

Regards,

Lin
- DebbieE
  Community Champion
  6 years ago
  I have done everything the document says and its still failing
Nimrod_Shalit
Power BI Team
6 years ago
DebbieE,
it sounds like it should work.
can you share more info on the datasource type and connection type,
or how are you using the param as part of the connection?
- DebbieE
  Community Champion
  6 years ago
  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.
  - Nimrod_Shalit
    Power BI Team
    6 years ago
    Thanks for the thorough information.
    regarding data source rules- this can't work if you already parameterized the server and DB,
    it can only work with parameters now.
    regarding parameters- please opena support ticket so we can further investigate.
    if you have pipeline ID and error IDs, please provide them.