Power BI Embedded Change data sources dynamically

[AnaMariaDe]

Hi all,

I am facing with this scenario:Power BI report embedded in an application connected to SQL server using Gateway.

I want to use the same report (Report ID, Workspace ID) but change the data source dynamically
Each clients maintains a database with same schema.Each database is composed in this way Schema_1234_123456
We have a database that holds information regarding the list of database for the clients.
I want to pass in the databaseId through query paramenter from the report URL and the report should pick the right database using the databaseId and dynamically change the datasource. Is this possible?

Thank you for your time

[AnaMariaDe]

Hi @v-mengmli-msft,

Thank you for your kind support.

In my scenario, each customer uses the same datasource, which is the "Test" database. However, they use different schemas that have the same tables with the same structure. For example:

• Customer 1 uses Schema_1234_123456.Table1 and Schema_1234_123456.Table2.
• Customer 2 uses Schema_3333_444444.Table1 and Schema_3333_444444.Table2.

Now, I want to pass only the information from Schema_1234_123456, which is used by Customer 1, and update the report. Is this possible?

If Customer 2 is using Schema_3333_444444, they should see the report updated with data from Schema_3333_444444.

Thank you,

Ana

[v-mengmli-msft]

Hi @AnaMariaDe ,

As far as I know, currently Power BI doesn't support dynamically changing the connected database. Because different people see different data sources and need different credentials, and Power BI is temporarily unable to automatically change credentials. I recommend that you create different reports and connect to different data sources.

Best regards,

Rimmon Li