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. 
Need Help
  • 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

Deku's avatar
Deku
Super User
1 year ago

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
    1 year ago

    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
      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