Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DaveFL
New Member

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.

 

 

1 ACCEPTED SOLUTION
PowerDAX
Resolver III
Resolver III

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"
}
powerdax.com

View solution in original post

1 REPLY 1
PowerDAX
Resolver III
Resolver III

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"
}
powerdax.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors