Update dataset refresh timing into excel using power automate

[prathmeshb27]

Can anyone help me do this? Update dataset refresh timing into excel using power automate. when dataset refreshes in power bi service workspace the refresh time should get updated in excel sheet in front of dataset name

[v-prasare]

@prathmeshb27, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super users for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@prathmeshb27, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super users for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@prathmeshb27 , As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super users for your issue worked? or let us know if you need any further assistance here?

@anilelmastasi, Thanks for your promt response here.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[anilelmastasi · Accepted solution]

Hello @prathmeshb27 ,

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!

[prathmeshb27]

Your solution will work but these connectors are not visible in power automate.  (Select "When a dataflow refresh completes" or "When a dataset refreshes" (depending on what you're using).)