Forum Discussion
Query Folding - ODBC
Hi Anonymous ,
1.The View Native Query option is only available for certain relational DB/SQL generating connectors. It doesn't work for OData based connectors, for example, even though there is folding occurring on the backend. The Query Diagnostics feature is the best way to see what folding has occurred for non-SQL connectors (although the steps that fold aren't explicitly called out—you just see the resulting URL that was generated).
2.Query folding supports SQL Server, Oracle, and data sources that support ODBC connectivity.
Excel, CSV, and website are not supported.( Data sources without any query mechanism).
3.If the query statement is preconfigured before connecting the data source, query folding will not work.
4.Note that when a Power Query query encompasses multiple data sources, incompatibility of data source privacy levels can prevent query folding from taking place.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
1.The View Native Query option is only available for certain relational DB/SQL generating connectors. It doesn't work for OData based connectors, for example, even though there is folding occurring on the backend. The Query Diagnostics feature is the best way to see what folding has occurred for non-SQL connectors (although the steps that fold aren't explicitly called out—you just see the resulting URL that was generated).
2.Query folding supports SQL Server, Oracle, and data sources that support ODBC connectivity.
Excel, CSV, and website are not supported.( Data sources without any query mechanism).
3.If the query statement is preconfigured before connecting the data source, query folding will not work.
4.Note that when a Power Query query encompasses multiple data sources, incompatibility of data source privacy levels can prevent query folding from taking place.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.