PowerBI - Query Folding Question


#1

In PowerBi /powerQuery there is a concept of query folding which pushes some of the manipulations that are done in the tool back to the source.

  1. is this feature supported in Panoply?
  2. if it is, and the query is working would I see if come back in the query log as an addition request, post the initial query?

#2

Query folding involves PowerBi’s folding the query out of M language and into the source side language to handle the transformation on the DB side. In theory this would be supported by Panoply; however, little documentation exists around what languages PowerBI can support and fold into. Understanding that MSSql and Redshift Sql have some key differences there are likely cases where query folding will not be supported.