Forum Discussion
Incremental Refresh Power BI
No prob. Glad to help. If anything I have said helps, please "accept as solution" for that part so this thread can be known to be solved.
This is the M code in use to create the list that broken the query folding. and when I ran diagnostic in the query there is a warning about query folding. Do you happen to have a way to create a list of dates without breaking the query folding? M formula use to calculate the listDiagnostic ran for that custom column
You can't. A List is a Power Query object, not a SQL Server object, so nothing to send back. But you may still do this if you use it correctly. See this article.
I generate a list. It can come from anywhere. Then I pass that list to List.Contains in SQL Server via a Table.SelectRows() function. It folds using the in operator.