Forum Discussion
Solved
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 ...
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" }
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"
}