topic Re: Does Power BI Report Server support incremental refresh? in Report Server

Does Power BI Report Server support incremental refresh?

igorpereiradaco — Sat, 08 Feb 2025 14:19:30 GMT

Does Power BI Report Server support incremental refresh?

Re: Does Power BI Report Server support incremental refresh?

Fowmy — Sat, 08 Feb 2025 14:42:28 GMT

igorpereiradaco

incremental refresh is not supported in Report Server, I suggest you handle this at source level.

Re: Does Power BI Report Server support incremental refresh?

igorpereiradaco — Sun, 09 Feb 2025 16:50:37 GMT

How could I handle this at the source level?

Re: Does Power BI Report Server support incremental refresh?

Fowmy — Sun, 09 Feb 2025 20:10:44 GMT

igorpereiradaco

This involves modifying your data source to support incremental refresh. For instance, if your data source is a SQL database, you can:

- Maintain Timestamps: Ensure that your tables include a column with timestamps (like a LastUpdated column) to track changes.

- Create Views or Stored Procedures: Develop SQL views or stored procedures that return only new or changed records based on the timestamp column.

- Schedule Data Loads: Use tools like SQL Server Agent to run these views or stored procedures periodically, importing only the necessary incremental data into your reporting tables