Forum Discussion
Sharepoint folder excel live update
In Power Automate, create an Automated cloud flow. Use the trigger “SharePoint - When a file is created or modified (properties only)” and select your Site, Library, and folder (add a Condition if you want it to run only for file.xlsx). Add the action “Power BI (Fabric) - Refresh a semantic model” (or “Refresh a dataset”), then choose the workspace and model. Save and test. Whenever the Excel file changes, the flow runs and triggers a dataset refresh. You need workspace permission, the dataset’s SharePoint credentials must be set, the report updates only after the refresh finishes, and you can add a short Delay step to avoid multiple refreshes during rapid edits.
Hi rohit1991 ,
can you please share some more details on second option you mentioned using power automate "Use Power Automate to trigger a dataset refresh whenever the file is modified". I am not clear what it means
In Power Automate, create an Automated cloud flow. Use the trigger “SharePoint - When a file is created or modified (properties only)” and select your Site, Library, and folder (add a Condition if you want it to run only for file.xlsx). Add the action “Power BI (Fabric) - Refresh a semantic model” (or “Refresh a dataset”), then choose the workspace and model. Save and test. Whenever the Excel file changes, the flow runs and triggers a dataset refresh. You need workspace permission, the dataset’s SharePoint credentials must be set, the report updates only after the refresh finishes, and you can add a short Delay step to avoid multiple refreshes during rapid edits.