imeData Refresh Time

[dia612]

Hello,

I have created a report by getting data from Sql server using views and stored procedures.

When I load them into .pbix file for the first time , it took me like 5-6 min.

But everytime I refresh manually in the pbix file to get the new records , it is taking 5-6 min.

I mean it is loading every record again instead of loading only the newly entered records.

Is this how it works??

Cant we reduce the refresh time ??Cant we load only the newly new records???

[amitchandak]

@dia612 , you need to configure Incremental

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-...

[lkalawski]

Hi @dia612

Yes, you load all the data every time. If you only want to load new data, use incremental refresh.
Read more about it here: https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

_______________
If I helped, please accept the solution and give kudos! 😀