How to pass database schema to PowerBI embedded

[apoloduvalis]

I have a web application in which I have embedded a PowerBI report. My application is multitenant, which means each customer access their own database schema in the application's database. I would like to send through javascript the schema corresponding to the user's session to the embedded PowerBI report, so it can run SQL queries using the received schema like this.

select id, description
from [@schema].products

I used to send a filter through javascript when all customers shared the same database schema, but now that each customer has their own database schema I want to make it dynamic, so my customer in tenant1 can see data coming from tenant1_schema.products while other customer in tenant2 see their data coming from tenant2_schema.products.

How can I do that? 

[Anonymous]

Hi @apoloduvalis ,

You can follow the steps below to get it:

1. Create a parameter for the report in Power BI Desktop

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Populate a Power BI parameter list using a query

2. Publish the report to Service

3. Embed the report

Embed content in your Power BI embedded analytics application - Power BI | Microsoft Learn

Use service principal profiles to manage customer data in multitenant apps - Power BI | Microsoft Le...

4. Pass Schema Parameter Dynamically Through JavaScript

Passing parameters to Power BI filter programmatically - Stack Overflow

Solved: Pass parameters dynamically from Power BI to REST ... - Microsoft Fabric Community

Best Regards

[apoloduvalis]

Thank you for your answer @Anonymous 

The problem with your solution is that by passing a filter from the javascript client only filters a query that has already been executed. The value passed as a filter is not taken as a parameter by the report. So far, it seems like parameters only work on PowerBI desktop. I do not see how to make the report to accept the filter as a parameter.