Reply
Highlighted
Occasional Visitor
Posts: 1
Registered: ‎03-10-2017
Accepted Solution

Multi Tenancy From Desktop Application

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.

 

 


Accepted Solutions
Regular Visitor
Posts: 56
Registered: ‎08-09-2015

Re: Multi Tenancy From Desktop Application

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"
}

View solution in original post


All Replies
Regular Visitor
Posts: 56
Registered: ‎08-09-2015

Re: Multi Tenancy From Desktop Application

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"
}