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?
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.