Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Done

when parameter is used with in sql query , datasource rules not able to be set in deployment pipelin

Hi Team,

 

I have tried to parameterize the schema in a sql query used to load a table in powerbi, since schema is different for prod env . Now if this is set Im not able to set the deployment datasource rule to change the database server and name in deployment pipeline settings. Both database server and name are not parameterized only schema with in the query is parameterized. Please help if you have any previous experience on this or you know the solution

Report Server
Reports

1 Comment

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Data source rule can't contain a parameter

    Your rule can't be applied because the server name or database name referenced in the rule is controlled by a parameter. To change the server or database name, use a parameter rule or remove the controlling parameter from configured item.

     

    For more you may refer to Troubleshoot deployment pipelines, the Power BI Application lifecycle management (ALM) tool - Power BI | Microsoft Docs 

     

    Best Regards,
    Community Support Team _ Caitlyn

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

Completed Ideas