Managing content for multiple clients having different datasets (but same structure and datamodel)

[mwroblewski]

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 server) with same schema and structure. We want to manage our content for all of them in the least painful way (in SSRS it was working nicely for us). The idea is to maintain our dataset (datamodel) with paramter "ServerName" and have one version of each report, just pin in to different datasets. Question: what's the best way to deal with it? Template apps ?

Second questoin, what's the most efficent way to aggrgate this data across multiple clinets. Is there some better apprach than merging queires within one dataset ?

Looking for any advice!

[Sahir_Maharaj]

With DirectQuery or Live Connection and dataflows, you can aggregate the data at the data source level and avoid these issues.

[Sahir_Maharaj]

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.

[Sahir_Maharaj]

Hi @mwroblewski,

For your first question, using Power BI Template Apps might be a good approach. This will allow you to maintain a single version of the report and use a parameter "ServerName" to switch between the different client databases.