How to do incremental refresh in power bi?

[Anonymous]

I have made a dashboard in power bi. I want to do incremental refresh in real-time i.e. if I update the data in the excel sheet it automatically updates the data on the same day within seconds or minutes.

[Joe_Barry · Accepted solution]

Hi @Anonymous 

This article will fill you in. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive

One tip fom me, always use a SharePoint folder. Save the Excel there and import the file from there.

Joe

[Anonymous · Accepted solution]

Hi,

Thanks for the solution @Joe_Barry  provided, and i want to offer some more information for user to refer to.

hello @Anonymous , based on your description, if you want to implement the incremental refresh, you need to put the file to a folder or sharepioint, you can refer to the following link.

https://www.thepoweruser.com/2020/01/19/incremental-refresh-for-files-in-a-folder-or-sharepoint-power-bi/

And the following document is about the incremental refresh.

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Joe_Barry · Accepted solution]

Hi @Anonymous 

This article will fill you in. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive

One tip fom me, always use a SharePoint folder. Save the Excel there and import the file from there.

Joe