Unable to M query can be folded. incremental refresh can't be suggested for non-foldable queries.

[LankelaAnilRedd]

I am getting following error "Unable to M query can be folded. incremental refresh can't be suggested for non-foldable queries."

my datasource is Plsql views. getting data through odbc. view native query is able to see till navigation step and next steps disabled. here i have removed all the steps after navigation and applied incremental refresh but same error i am facing. Please help me.

[LankelaAnilRedd]

Hi,

Thanks for the help.
After navigation step query folding disabled for next steps. So, for checking native query functionality i have removed all steps and kept only source and navigation steps but getting same error "M query not folded and incremental refresh not suggested for non foldable queries"

[Anonymous]

Hi  @LankelaAnilRedd ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous · Accepted solution]

Hi @LankelaAnilRedd,

As this official documentation referred, the data sources like relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory support query folding. And some transformations may prevent query folding, please review the list below and check if there is any following transformation step in your query.

• Merging queries based on different sources.

• Appending (union-ing) queries based on different sources.

• Adding custom columns with complex logic. Complex logic implies the use of M functions that have no equivalent functions in the data source. For example, the following expressions format the OrderDate column value (to return a text value).

  

• Adding index columns.

And the following blogs decribe the fixing of query folding, hope they can help you.

Fixing Query Folding with SQL Server in Power BI for Incremental Refresh

Power BI — Incremental refresh and the struggles of query folding

Best Regards

[amitchandak]

@LankelaAnilRedd , Most of the time when you have a query, Power  bi will not able to fold the query means able to generate a native query

refer video from guyinacube : https://www.youtube.com/watch?v=8hjdOCni_ZY