Forum Discussion
Solved
Query Folding & Incremental Refresh
Ok stick with me here. We are updating our reports to utilise PowerBI Pro now being able to utilise Incremental Refresh (Yay!) We made all the required changes, parameter editions filtered rows ...
- Previews limit what is shown and returned and I wouldn’t trust those to reflect what really happens on a full refresh. Only analyze that kind of data.
You can use YYYYMMDD as a date for incremental refresh. See https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Just do the incremental refresh before any transformations that you know are going to break folding. It is all about optimizations.
Previews limit what is shown and returned and I wouldn’t trust those to reflect what really happens on a full refresh. Only analyze that kind of data.
You can use YYYYMMDD as a date for incremental refresh. See https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Just do the incremental refresh before any transformations that you know are going to break folding. It is all about optimizations.
You can use YYYYMMDD as a date for incremental refresh. See https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Just do the incremental refresh before any transformations that you know are going to break folding. It is all about optimizations.
by the way shaunwilks - take a look at this Guy in a Cube video. There are times the "View Native Query" option is grayed out yet folding is still happening! He shows how to use Power Query diagnostics to get a detailed list of the communications between PQ and your SQL Server.