Incremental data refresh for POWER BI Report Server

[AvinashPentyala]

Dear All,

Power BI dataset was created Import mode, Please advise is there any way to process the incremental data loading in report server?

[johnbasha33]

@AvinashPentyala 

No, incremental refresh is not available in Power BI Report Server. However, you can use SQL Server Analysis Services tabular to do incremental refresh on-prem and live connect from your PBIX reports.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[AvinashPentyala]

Okay, What is max size limit for data set in report server? is ther any way to change to Direct mode from Import?

Also, facing issue with data refresh in server level, Table has around 25M records getting connection timeout error.