Forum Discussion
dynamic API call depending on selected project
Hi Anonymous thanks for your quick message. the API call works flexibly depending on what you put in the parameter. My question now is if I can populate the parameter dynamically depending on what the user selects. I have seen that this works for DirectQuery via "Bind Paramter". However, my source is a REST API and I can't set the storage mode to DirectQuery. Is there any other way to implement this?
Hi Anonymous - you are correct - Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn will not work if you cannot set the data source to Direct Query.
If you have a limited number of users accessing the data, you may consider Power App that allows the user define the parameter, then trigger a Flow to update parameter and refresh the dataset. I think you need to use the Power BI Rest API for this as Power Apps and Power Automate connectors don't have update parameter feature.
Datasets - Update Parameters In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Note that depending on the capacity you may be limited by the number of changes that a user can make in 24 hour period.