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.

[v-aatheeque · Accepted solution]

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.

[Akash_Varuna · Accepted solution]

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 ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

If you have any further questions or need additional assistance, please feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @saaquib 

If a community member and our response has addressed your query, please mark their response as "Accept Answer" and click "Yes" if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @saaquib ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

If you have any further questions or need additional assistance, please feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque · Accepted solution]

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.