Forum Discussion
Embedded report with dynamically changing data source
Thank you very much for your reply.
Maybe to clear it up a little:
I wanted to change the underlying source of the dataset (an API like https:// myurl. com/year_month_day, where year, month and day are replaced by parameters. The schema of the APIs remains the same) by passing the values of the parameters via the embedding call (I used the ngx-powerbi component) in the code of an angular-based web app.
It should be done automatically so that changing manually over desktop or service is not what I'm looking for.
So, did I get it right that there is no real solution to my problem in Power BI? Or does your suggested solution with the Power BI Service API to automate the parameter value change fit my problem and if so, how can I apply it?
Microsoft EmployeeYes, you can change paremeter values with the Power BI Service API. Therefore, you will not be required to update parameters by hand in the Power BI portal.
Just remember that changing parameters affects all users and it is something you do occasionally and not frequently. As long as you design fits in with these assumptions, you can build solutions using parameters.
Once again, I see quite a few people who want to change dataset parameters values that take effect within the context of a single request. The goal of these people is to have several users executing requests at the same time while each users gets a common dataset to rediected to a different data source. This functionality is defintely not supported.