Forum Discussion
Does Power BI Report Server support incremental refresh?
Does Power BI Report Server support incremental refresh?
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
3 Replies
igorpereiradaco
incremental refresh is not supported in Report Server, I suggest you handle this at source level.How could I handle this at the source level?
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
