Forum Discussion

srana's avatar
srana
Frequent Visitor
4 years ago

Deployment Pipeline in Power Bi

Hi guys,

 

My report consists of multiple data sources & I'm not able to change the parameters in deployment pipeline. I was able to change for the report that has one data source but it's not working when the report consists of multiple data sources.

Please help me out with this.

 

Thanks in advance.

Need Help

11 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    4 years ago

    Hi srana ,

     

    Have you reveiwed the following link's Considerations and limitations?  Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs  Do any of those apply to you?  Also, are you sure that you have permissions to all of the data sources? 

    When you state that you can change one data source's parameters do you mean that you have tested EACH data source separately and you can do each one individually - but you can't just do it when those same data sources are together?

    For the service and the rules have you considered these limitations?  Get started using deployment pipelines, the Power BI Application lifecycle management (ALM) tool - Power BI | Microsoft Docs  Particularly, are you an owner or is the datasource(s) in the CDM or other limits?

    • srana's avatar
      srana
      Frequent Visitor
      4 years ago

      Hi collinq ,

      Thanks for the solution it does make sense.

      After reading your solution I tried using it with one data source but this time in the parameter rule it is not giving me the option for changing the database name / not showing me the database name that I've used ; it is only showing me the server name.

      Please suggest me a solution for this.


       

      • collinq's avatar
        collinq
        Icon for Super User rankSuper User
        4 years ago

        Hi srana ,

         

        That sounds very much like a permissions issue to me.  If you can see the server, but not the database that indicates to me that the permissions are not set for you to see from that database.  That would be worth a call to the database administrator to determine if you (or the userid that is being used) has permissions.

  • srana's avatar
    srana
    Frequent Visitor
    4 years ago

    Hi,

     

    I have 10 parameters used in my report but here it allows me to change only for 4 parameters. 

     

     

    • abpgupta's avatar
      abpgupta
      Icon for Continued Contributor rankContinued Contributor
      4 years ago

      You should update directly parameters from Dataset settings. I had multiple issues in using configuration rules inside Deployment Pipeline.

    • Nimrod_Shalit's avatar
      Nimrod_Shalit
      Icon for Power BI Team rankPower BI Team
      4 years ago


      srana, abpgupta - if you have issues with setting up rules, please open a support tickets. This shouldn't be the experience you are facing. Please provide as much details and screenshots on what you are facing, so we can investigate and help.

      • abpgupta's avatar
        abpgupta
        Icon for Continued Contributor rankContinued Contributor
        4 years ago

        We did open tickets for the issues with deployment pipeline showing differences when parameter values are changed.  Ultimately we were asked to remove them to resolve the issues.