Forum Discussion
AnaMariaDe
1 year agoRegular Visitor
Power BI Embedded Change data sources dynamically
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 da...
AnaMariaDe
1 year agoRegular Visitor
Hi Anonymous,
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