Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
User232431
Helper II
Helper II

Refresh all the dataset's in piblished report

Hi , I have a dashbord published in the services with multiple dataset's which are linked to onedrive csv files individually.

How can we refresh the dashboard when all the csv files in onedrive were updated / modified. 

please suggest me any power automate flow / documents solving the same issue.

Below is the screen shot of datasets from published 

User232431_0-1741151760007.png

 

Thanks.

1 ACCEPTED SOLUTION
arvindsingh802
Super User
Super User

Steps to Set Up Power Automate Flow

  1. CreateAutomated cloud flow.
  1. Trigger the flow when the file is updated:
    • Choose "When a file is modified (properties only)" (for SharePoint)
  2. Add an action to refresh the Power BI dataset:
    • Click "New Step".
    • Search for Power BI and select "Refresh a dataset".
    • Select the workspace where the dataset is located.
    • Select the dataset you want to refresh.
  3. Save and Test the flow:
    • Click Save and Test by modifying the target file.

Refer https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/ for details information


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

2 REPLIES 2
arvindsingh802
Super User
Super User

Steps to Set Up Power Automate Flow

  1. CreateAutomated cloud flow.
  1. Trigger the flow when the file is updated:
    • Choose "When a file is modified (properties only)" (for SharePoint)
  2. Add an action to refresh the Power BI dataset:
    • Click "New Step".
    • Search for Power BI and select "Refresh a dataset".
    • Select the workspace where the dataset is located.
    • Select the dataset you want to refresh.
  3. Save and Test the flow:
    • Click Save and Test by modifying the target file.

Refer https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/ for details information


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Hi thanks for your immediate reply , can we create this with "oneDrive" files and do i need to create multiple flows for multiple tables to be refreshed?

Thanks.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors