Unanswered

Update Power BI Report using Power Automate

(0) Share

Report

Posted on by vasu-sharma

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!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Hi
What kind of processing status do you mean? Is it the flow? What is the trigger to change the status?
This joined table including the status column is also coming from an excel file?
The status must be changed in the source to be reflected in the report itself...

Was this reply helpful? Yes No
vasu-sharma 5 on at

Like (0)

Report
Copy link

Link copied!

So, the flow is something like this:

Power Automate Flow 1 (triggered every 2 hours):
1. Read the data from a table in Power BI report (the table has a column "Status", we're only reading the records where "Status" is null).
2. Load the data into SharePoint List.

Flow 2 (triggered when new item is created in a SharePoint List):
1. Creates an approval for that SharePoint List item, there are 3 conditional approvals based on some column values
2. For the items that are awaiting approval, I want to update the approval status as "Pending" in the Power BI report which was used as a data source in Flow 1. - is there anyway to achieve this?

The "Status" column that I want to update is coming from an Excel file. I can update the Excel file but I'm guessing there would be a complex lookup involved here because the original data source is a join of 15-something tables.

Was this reply helpful? Yes No