Forum Discussion
Dynamic DataSources in Power BI Report Builder
Hello! We have many clients that each have their own sql server and database but the database structure is the same across all instances. Instead of building the same report for each client, we creat...
GilbertQ I appreciate the response but RLS is not something we are struggling with. We already have a filtering solution based on who is using the report. It is an architectural decision to have each client on their own database and hoping we can find a solution on the reporting side to support that.
Hi MeganBig
Unfortunately as Power BI is currently designed there is no way to dynamically create a data source per customer. You might be able to automate it by using the REST API to create the data sources?
Gateways - Create Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Learn
