Forum Discussion
Pivote columns refresh error
Hi all, I'm having problems when trying to refresh my Power Bi Report. I'm maintaining a report, which is using SQL Server and Sharepoint (with excel files) as two main sources. Report is middle ...
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.
Yessir, it sends the list as an IN clause, like
Customer ID IN (A12345, A42956, A23584, A65485, A46584).
--Nate
Beautiful. Thanks 🙂