Forum Discussion
Query Folding and Access Native Query for Incremental Refresh
I am using data from Teradata and I have it brought in using Import mode. The table is huge with 100s of millions of rows at 50+ columns. I want to set up incremental refresh for this table to optimi...
What happens if instead of fancy M logic like this, you query the table directly and then build your transformation steps in Power Query? Does that allow query folding at ALL levels? Does it even do query folding at the top SELECT step?
My thought process was to do all transformations prior to loading it into PBI to lessen the load. Then just load the query in using import mode and apply incremental refreshing to the report to make it even swifter