Hi Power Automate Community,
I have a complex semantic model with over 15 tables which is used to create a Power BI report. The data source is a bunch of Excel files, databases. The report is already in place.
I have to create a Power Automate flow that reads the data from one of the tables in the report (the table is a joined table), do some processing, and there is a status column that it needs to update to reflect the processing status like active, pending, complete, etc.
I know we can run a query against a dataset, but how can we update the processing status so that it reflects on Power BI report? What are the ways in which we can achieve this?
Thank you so much!