Reputation: 1372
actually i m working on a react app and want to send data in api body from the front end to an existing powerbi service report. and what i want is that the new data (that i send in body) should replace the existing data in the existing powerbi report and should refresh it.
I have searched a lot in their docs. They have Post APIs to refresh report and to replace data of one report to another, but unfortunately i could not find any apis that take json data value and replaces the data of current report with the new data or creates a new report based on json data.
I'm working on a react app and want to send data in api body from the front end to powerbi service report. and what i want is that the new data (that i send in body) should replace the existing data in the powerbi report and should refresh it.
I just wanted to know is it even possible with powerbi service or with power automate?
Upvotes: 0
Views: 340
Reputation: 88971
There's no way to do this as you describe.
The API could save the data into a database that supports DirectQuery then use the report export API passing a filter to reference the data you just inserted.
Or perhaps you can use a Push Dataset.
Upvotes: 0