Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Query folding with Oracle

I'm pulling in data from an Oracle database and tracking down when the "View Native Query" is greyed out.  I also believe that my transformations to the Oracle query are preventing scheduled refresh ...
Need Help
  • collinsg's avatar
    collinsg
    3 years ago

    Good day Anonymous ,

    This Microsoft article may answer your question, unfortunately not with the answer you would like "Query folding on native queries" - it is dated 17 Feb 2023 and suggests these data connectors are supported using the parameter "EnableFolding" set to true (but, unfortunately Oracle isn't listed): Amazon Redshift, Dataverse (when using enhanced compute), Google BigQuery, PostgreSQL, SAP HANA, Snowflake, SQL Server. 

     

    There are a couple of other articles I read in the past which may be of interest (though not with respect to Oracle) Chris Webb covers the topic in his blog article "Query Folding On SQL Queries In Power Query Using Value.NativeQuery() and EnableFolding=true". Patrick of Guy in a Cube has a video on the same subject "Enable Query Folding for Native Queries in Power Query / Power BI". Patrick speaks of it specifically in reference to Desktop.

     

    Folding may not matter, as you suggest, if your query refresh performance is already adequate. Or...since Dataverse is supported you could consider a staging query (with no or few transformations) to get the data into Dataverse quickly and then take it from there. This introduces two hops but could end up quicker overall.

    Hope this helps.

collinsg's avatar
collinsg
Solution Sage
3 years ago

Good day Anonymous ,

This Microsoft article may answer your question, unfortunately not with the answer you would like "Query folding on native queries" - it is dated 17 Feb 2023 and suggests these data connectors are supported using the parameter "EnableFolding" set to true (but, unfortunately Oracle isn't listed): Amazon Redshift, Dataverse (when using enhanced compute), Google BigQuery, PostgreSQL, SAP HANA, Snowflake, SQL Server. 

 

There are a couple of other articles I read in the past which may be of interest (though not with respect to Oracle) Chris Webb covers the topic in his blog article "Query Folding On SQL Queries In Power Query Using Value.NativeQuery() and EnableFolding=true". Patrick of Guy in a Cube has a video on the same subject "Enable Query Folding for Native Queries in Power Query / Power BI". Patrick speaks of it specifically in reference to Desktop.

 

Folding may not matter, as you suggest, if your query refresh performance is already adequate. Or...since Dataverse is supported you could consider a staging query (with no or few transformations) to get the data into Dataverse quickly and then take it from there. This introduces two hops but could end up quicker overall.

Hope this helps.