topic Re: Multi Tenancy From Desktop Application in Developer

Multi Tenancy From Desktop Application

DaveFL — Fri, 10 Mar 2017 16:00:15 GMT

Hi;

I am looking at the feasability of swtiching from our current BI solution to Power BI but ran into a question that I cannot seem to find an answer to.

1 - Each of our clients have their own database.

2 - Currently we embed a broswer into our desktop application, and then browse to the requested dashboard.

3 - We are an SAAS company and currently host all the "cubes" of data. There is a cube per client, each points to a different server/database.

4 - The datasets/cubes are all identical, the only difference is the data source.

5 - Security is controlled by our application based on the user that logs in.

Is this possible with Power BI? I have been reading through the Power BI Embedded information, but I cant quite pin down if it supports this.

Re: Multi Tenancy From Desktop Application

PowerDAX — Sat, 11 Mar 2017 17:39:38 GMT

See the extract from here: https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-iframe

In production, we can also set the different connection string for each workspace using REST API. (i.e, we can separate the database for each customers.)

The following is changing the connection string of datasource via REST.

POST https://api.powerbi.com/v1.0/collections/mypbiapp/workspaces/32960a09-6366-4208-a8bb-9e0678cdbb9d/datasets/458e0451-7215-4029-80b3-9627bf3417b0/Default.SetAllConnections
Authorization: AppKey MpaUgrTv5e...
Content-Type: application/json; charset=utf-8

{
  "connectionString": "data source=testserver02.database.windows.net;initial catalog=testdb02;persist security info=True;encrypt=True;trustservercertificate=False"
}