Data Refresh takes lot of time to refresh data

[saaquib]

Whenever I refresh or scheduled refresh my power bi reports on power bi services it takes lot of time, It fetch all old data (rows) and new data (rows) while refreshing but it does not only fetch new rows of data is there any way it only fetch new data (rows) by which it does not take more time to refresh the data.

[Akash_Varuna]

Hi @saaquib , To refresh or load only recent data please use Incrimental refresh in Power BI this will only load the newly added data and will increase the performance Below are the steps

• In Power Query, create two parameters: RangeStart and RangeEnd.
• Set their data type to Date/Time.
• In Power Query, apply a filter on the date column using RangeStart and RangeEnd.
• Use >= for RangeStart and < for RangeEnd.
• Publish the Report/Model to Power BI Service
• Select your table in the Fields pane.
• Go to Modeling > Incremental Refresh.
• Define the refresh policy
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[v-aatheeque]

Hi @saaquib ,

Thanks for reaching out to the Microsoft Fabric Community forum.

To configure Power BI to only refresh new data rows, you can use the Incremental Refresh feature. This allows you to set up your dataset to only load new or updated rows based on a defined date column.

In Power Query, create two parameters named StartDate and EndDate. These parameters will be used to filter the date column of your data table.

you should look at incremental refresh. Refer to this link : https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

please consider this reply as "Accept as Solution" and click on "Yes" so that other community members will find it more quickly.

If you continue to face issues, feel free to reach out to us for further assistance!

Regards,
Abdul.