Forum Discussion
Pivote columns refresh error
Buffering doesn't affect folding. It affects speed. It gathers all of the items in the list at once, then sends the buffered list to the SQL server in the IN clause.
If you don't buffer, it streams the data into the IN clause and takes significantly longer.
As a result, folding or not, I always use a buffered list for List.Contains. And yup, Anonymous taught that trick to me.
Anonymous ,
Yes, your query will fold up until the step that you break it, then all subsequent steps will be completed locally.
You can check if/where folding is broken by right-clicking on each of your steps and checking if 'View Native Query' is available. If it is, then your query is folding to the server with the native SQL that can be viewed by clicking that button. If it's greyed-out, then that step is not being folded.
Pete
That sounds great, in fact, I haven't exactly specified my table source, I'm using SQL Server Analysis Services, so I guess should use DAX or MDX language, as it is the native language (according to what i I've in microsoft docs)