How to change power bi data source parameter in .NET MVC application ?

[vikramkumawat]

Hello,

I made a Power BI report that connects to a SQL database and lets me change databases by updating a parameter. This works well when I publish the report and change the parameter in Power BI online. Now, I want to add this report to a .NET MVC application. I need to know how to change the database parameter from within the .NET app, like I can in Power BI online. Is it possible to do this?

Thanks.

[vikramkumawat]

@Anonymous thank you for your reply.

Your solution will work and it will update the Paramter which is being used to fetch the database.

The scernario is, we have multi tenant application and each tenant has it's own database. Now, we want to load the report for the logged in tenant.

e.g. if the Tenant1 is logged in then our mvc application should pass the Tenant database name as parameter value and it should load the report for that tenant, if Tenant2 logged in then it should load the report for that tenant only and so on.

So is it possible?

[Anonymous]

Hi @vikramkumawat ,

Base on your description, it seems like you want to change the database parameter from within the .NET app as you can in Power BI. Please try the following steps and check if can achieve your requirement:

1.  Embed the report: 

          Creating Embedded Reports in Your Web Apps with Power BI Embedded (codemag.com)

          Embed Power BI report in a Power BI embedded analytics application for your organization - Power BI

      2. Pass the dynamic parameter to embed report in .NET:

         Power BI Embedded Query Parameters API | Azure updates | Microsoft Azure

         Can I pass a dynamic query parameter to an embedded Power BI report in ASP.Net MVC? - Stack Overflow

Best Regards