Forum Discussion
How change the data source dynamically in power bi report
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.
1 Reply
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.
