Forum Discussion
How to pass database schema to PowerBI embedded
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?
2 Replies
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
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
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.
