Forum Discussion
incremental refresh for report server
I would like to confirm whether incremental refresh functionality is supported in Power BI Report Server, similar to what is available in Power BI Service. If it is not natively supported, are there any recommended alternatives or configurations to achieve an equivalent solution within Power BI Report Server?
I appreciate any guidance regarding limitations, configurations, or suggested strategies for this scenario.
2 Replies
I dont think Report server supports incremental refresh, one alternative is to build the tabular model in the SSAS and build your tables and partitions in it. Then you can use it as datasource in your report.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Thanks for tharunkumarRTK's concern about this issue.
Hi, AnalistaLH
As stated by tharunkumarRTK , Power BI Report Server does not support the incremental refresh feature like Power BI Service.
Solved: Incremental Referesh in Report Server - Microsoft Fabric Community
This can be done by using SSAS as the data source, which supports incremental refresh. This requires setting up partitions in SSAS and configuring Power BI reports to use those partitions.
Partitions in Analysis Services tabular models | Microsoft Learn
Create and Manage Tabular Model Partitions | Microsoft Learn
If your data source supports it, you can use DirectQuery mode to ensure that the report always reflects the latest data without having to completely refresh it.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
