Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

Sharepoint folder excel live update

i have excel file located inside sharepoint folder, i want to connect power bi with this file so that if anyone update data in excel file it should immediately reflect in power bi report without refr...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi powerbiexpert22 

     

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi powerbiexpert22 ,

Thanks rohit1991  for sharing the detailed steps.

Did you get a chance to look into the solution shared above? If not, I’d recommend following it using the Power Automate “When a file is created or modified” trigger linked to a Power BI dataset refresh will ensure your report updates automatically after changes to your Excel in SharePoint. It’s the most reliable approach given Excel can’t be used in true DirectQuery mode.

Regards,
Akhil.