Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.