Forum Discussion

rachidAlan's avatar
rachidAlan
New Member
7 years ago

Best options for automatic data refresh

Hello Experts,  I m pretty new to PowerBi and still learning about all possible options. I m now in a situation where a customer, who is using dynamics 365 onpremise, wants to use powerbi for repo...
Data Refreshes
Report Server
Report Server + PBI On Permises
luisrh's avatar
luisrh
Responsive Resident
7 years ago

When dealing with large datasets it is a good idea to implement incremental loading of the model.   MSFT is working on an incremental load approach for PBI models and it shows as 'planned'.   There are some workarounds as well,  but the most straightforward way is to use a Tabular model in Analysis Services to accomplish this.   Basically you load your data incrementally through a "Process Add" approach.   Note that this requires the load happening on SSAS and not in Power BI scheduler -  if you are working with such large data and need more control on loads  SSAS is something you should consider.   The article below has the details on what you can do to implement a true incremental load that Power BI can leverage for reporting.,

https://www.sqlbi.com/articles/incremental-processing-in-tabular-using-process-add/

 

Good luck!

Luis