Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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" }