Forum Discussion
How to automatically refresh power bi report once sharepoint file updated in sharepoint
Good morning All.
Can anyone please guide me how i can import excel data available in sharepoint and after publishing report of power bi in service how it refresh automatically once data update in sheet available in sharepoint.
Regards,
Faraz Ahmad.
You don't need to do it in Power BI Desktop. Log in to -> https://powerautomate.microsoft.com/en-us/ and create the flow.
8 Replies
SivaManiResident Rockstar
Faraz_Ahmad Power Automate will do the job for you.
Check out this blog - https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Thank You very much this is exactly what i am looking for, but this post not covered complete steps.
Could you please guide me for complete steps from loading data till scheduling refresh using powrer bi
- SivaMani
Faraz_Ahmad , Follow the below steps,
- Go to Power Automate portal -> Create -> Automated Cloud Flow
- Enter flow name and select 'When a file is created or modified in a folder' trigger as shown below
- Configure Site and Folder
- Add refresh Power BI dataset Step and configure the workspace and dataset
