Forum Discussion
Large dataset refresh issue
I have a larget dataset need to be refreshed daily. the process is fainful and slow. it's connected from dynamic CRM (or can be connected from SQL view). becase the past data won't change. for e...
Hi Anonymous,
For the table that contains “2016 or before” data , you can disable the “Include in Report Refresh” option in Query Editor of Power BI Desktop.
Regards,
Lydia Zhang
Anonymous thanks but it's just 1 able, 1 big table contain data from 1998-today. my question is can i ask it to refresh the data just for this year? but not 2016 and before?
Anonymous,
No. You would need to split your table and load your "2016 or before" data into another table, then disable the option for the table that contains "2016 or before" data. For more details, please review the following blog.
http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Regards,
Lydia