Can we change power bi dataset dynamically in .NET MVC application ?

[vikramkumawat]

Hello,

I have created a Power BI report using an SQL database and have also utilized parameters to dynamically change the database. I understand that we can modify the parameter value by accessing the semantic model settings in the Power BI service. However, I wish to dynamically adjust the parameter within the .NET MVC application where the report is embedded. How can I achieve this?

Thanks

[ibarrau]

Hi. I think the power bi rest api can help here. There is a request to update parameters of a dataset. It's this one: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters-in-group

I hope that helps,

[vikramkumawat]

Hi @ibarrau,

Thank you,  for your input. I'd like to clarify that I don't intend to update the parameters of the dataset. Instead, I want to switch between the values of the parameters, similar to the edit parameter functionality in Power BI Desktop. This way, I can dynamically update the dataset from the application directly.