Forum Discussion

Charlie86's avatar
Charlie86
Advocate I
5 years ago
Solved

Pipeline Deployment Seetings: replace data source -> invalid rule

Hi  I have a dataset (deployed with Tabular Editor) in my DEV workspace connected to a data source (Azure SQL DB) in our DEV Enviroment. I want to apply a data source rule in the pipeline TEST stag...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Charlie86 

If the data source defined in the rule is changed or deleted from the project it points to in the source phase, the rule will be invalid and the deployment will fail. You need to go to the dataset settings in the new app workspace. There you can make sure that the correct parameters are in place and you are logged into the data source.

You can refer to the link below .

https://community.powerbi.com/t5/Service/Deployment-pipelines-Parameters-Invalid-Rule/m-p/1173860

https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started#step-4---create-deployment-rules

 

Best Regards

Community Support Team _ Ailsa Tao

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

  • Charlie86's avatar
    Charlie86
    Advocate I
    5 years ago

    Hi  Anonymous 
    Thanks for your Answer.

    Dataset Settings "Data source credentials": there i can change my credentials but not the server name & database:

     

    Dataset Settings "Parameters": have to set them in query editor.

     

     

     

    So I changed my dataset in PowerBI-Desktop from live connection to Direct Query. I added the parameteres in Query Editor and republished the dataset to the service. I can edit parameters now...

     

     

      

    If I go to dataset settings: "data source credentials":
    server & database are still greyed out and the server changed from azure sql server to something else (?).

     

    I think I have to dig deeper.

    I was hopping that I can easily change sources in the different pipeline stages. But it seems that this is not so easy.

     

     

     

     

     

  • vinod472's avatar
    vinod472
    Regular Visitor
    3 years ago

    Did you find a way for this