Forum Discussion
Managing content for multiple clients having different datasets (but same structure and datamodel)
Dear community, We are struggling with two topics, but first let me quickly descirbe our setup. We are developing analytics for mutiple clients, each client has its own on-prem database (sql serv...
For your second question, using DirectQuery or Live Connection to the databases and creating a Power BI dataflow to aggregate the data from multiple clients would be the most efficient way. Merging queries within a single dataset can lead to performance issues and maintenance headaches, especially as the data grows.