Frithjof Aarrestad Vassbø on 11 Sep 2024 19:18:11
Because there is a potential for sync delay or sync issues between Lakehouse and SQL Analytics Endpoint, we wish to connect Power Query directly to Lakehouse.
This is possible e.g. with the Azure Data Lake Gen2 connector. However, it seems it doesn't support query folding.
We need a way to connect directly to the Lakehouse data (not SQL Analytics Endpoint) and still achieve query folding for performance reasons.