Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Client is having 16 db, where each db is having same set of schema info. Requirement is to change the data source dynamically,
Ex: Each country has seperate db with same schema info, Prompt is required for client to select db, for that report has to respond and provide corresponding visualization.
Is it possible in power bi service or desktop? or in any form of approach.
No, not in the manner you are describing really. I would look at Query Parameters as one possible vehicle. The other route would be to import all of the databases and use RLS.