Update dataset refresh timing into excel using power automate

Hello Anonymous ,

Yes! You can achieve this using Power Automate by setting up a flow that triggers when a dataset refreshes in Power BI Service and updates an Excel file accordingly. Follow these steps:

Step 1: Prepare Your Excel File
Create an Excel file and store it in OneDrive for Business or SharePoint (Power Automate needs cloud access).
Ensure the table format includes:
Dataset Name (Column A)
Last Refresh Time (Column B)
Make sure the Excel data is formatted as a table (Select Data > Format as Table in Excel).

Step 2: Create a Power Automate Flow
Go to Power Automate and click Create → Automated Cloud Flow.
Trigger:
Search for Power BI connector.
Select "When a dataflow refresh completes" or "When a dataset refreshes" (depending on what you're using).
Select your workspace and dataset.
Action: Get current timestamp:
Use "Get current time" (from "Date and Time" actions).
Action: Update the Excel sheet:
Choose "Excel for Business" → "Update a row".
Select OneDrive/SharePoint and choose the Excel file.
Choose the table where the dataset names are stored.
In the "Dataset Name" column, select the dataset that refreshed.
In the "Last Refresh Time" column, update it with the timestamp from Step 3.

Step 3: Save & Test
Click Save and Test the flow by manually refreshing the dataset in Power BI Service.
Check if the timestamp updates correctly in the Excel file.

If this helpful for your, please select as answer.

Thank you!