Usefull as reporting solution for multiple customers

[Franky]

We have an on premise sql server with multiple identical databases (only the data is different) on it for different customers.

Using an enterprise gateway it should be possible to publish reports on app.powerbi.com which use these databases as datasources.

But since these databases belongs to multiple customers, each customer should only be able to use the datasets from his database.

Is this possible using powerbi.

Or should we replicate our data which we want to use in the reports from our on premise sql server to  to sql azure (account of our client(s)) and publish the report in the powerbi subscription of our client(s) individual

[Bjoern · Accepted solution]

@Franky

Hi Franky,

if you want to publish the data into the database infrastructure of your clients, you would need acceess to their Power BI accounts etc. This sounds tricky, as most likely you have to setup each machine with an own AD etc., so the client users can authenticate against your infrastructure. Nevertheless, I see a complicated security architecture there.

Thus I would recommend the second option. Publishing data to client's Azure SQL DB sounds smarter. In the PBIX-file you could use the "live connect" and just replace the database name below it. Also, you do not have to care / centrally administrate all the clients accounts. Also, the security issue would not be that big.

BR