refresh dataset from sharepoint file is updated

[yellowold5]

Hi guys, I need help with this, I have a power bi report, source is excel file from sharepoint, the company have one person who is responsibility for that report, that person dont have any license for power bi.
Wonder now how he can update the dataset that we have in power bi service when he made some updates in the excel file from sharepoint? He don't update the file frequency so the schedule refresh is not a optional, any suggestion? 

[Idrissshatila]

Hello @yellowold5 ,

check this out https://youtu.be/ba1Akv63GDQ?si=JSC4BJ1GW_rG1V4H

[yellowold5]

Hi, thank you for your reply but shedule refresh was not a option becuase he dont update the file frequently, just wanna know if there are anothe solution then flow?

[Thejeswar]

Hi @yellowold5 ,

Set up a Power Automate flow that automatically triggers to refresh the Power BI Dataset whenever the file is changed by the User

Refer this

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

Regards,