Forum Discussion

apoloduvalis's avatar
apoloduvalis
Regular Visitor
2 years ago

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 li...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 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

  • apoloduvalis's avatar
    apoloduvalis
    Regular Visitor
    2 years ago

    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.