Forum Discussion

ssnegi1971's avatar
ssnegi1971
Frequent Visitor
1 year ago
Solved

Switch environments from dashboard

Hi,

 

Please tell me how to switch reports to different environments like dev, test, prod from the dashboard main page.

 

Thanking you in anticipation. 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ssnegi1971,

     

    Unfortunately, Power BI doesn't support dynamic switching of data sources at runtime via slicers. Slicers only filter data that’s already loaded, not the data source itself.

     

    Regards,

    Vinay Pabbu

8 Replies

  • Deku's avatar
    Deku
    Super User

    What do you mean by switch environment? Change the connection in the semantic model to different databases? Reconnect a report to a different semantic model?

     

    And are you taking about a dashboard or report?

    • ssnegi1971's avatar
      ssnegi1971
      Frequent Visitor

      If a report is fetching data from DEV tables I require a slicer on the dashboard page that can make it select data from PROD tables or any other environment in the slicer.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi ssnegi1971,

         

        Unfortunately, Power BI doesn't support dynamic switching of data sources at runtime via slicers. Slicers only filter data that’s already loaded, not the data source itself.

         

        Regards,

        Vinay Pabbu

  • ssnegi1971's avatar
    ssnegi1971
    Frequent Visitor

    Suppose a report is fetching data from DEV tables and I want to change the slicer on the dashboard page to fetch data from PROD. That is my query.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ssnegi1971,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Vinay Pabbu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi @ssnegi1971,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
      If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

       

      Regards,
      Vinay Pabbu

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi @ssnegi1971,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
        If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

         

        Regards,
        Vinay Pabbu