Forum Discussion
Dynamically DataBase Connection based on User Selection of the Database Name
Thanks for the reply from anmolmalviya05, Kedar_Pande and TomMartens , please allow me to add some more information:
Hi Anonymous ,
As far as I know, Power BI doesn't support this feature for now, the slicer can't dynamically switch the data source, the visual objects are only affected after loading the data into the semantic model.
You can try to use the use parameter or define a parameter SQL query as proposed in the link below:
Dynamically Change Data Source Using Parameter and... - Microsoft Fabric Community
You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
This is the related document, you can view this content:
Change data source dynamically using a Slicer by b... - Microsoft Fabric Community
Solved: Dynamically change data source - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.