Forum Discussion
Advocate IICan we change power bi dataset dynamically in .NET MVC application ?
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
2 Replies
- ibarrau
Super User
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,
vikramkumawatHi 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.
