Forum Discussion

Lucas234's avatar
Lucas234
Regular Visitor
3 years ago
Solved

Query folding for SQL database, Enabling? View Native Query

Dear Community, I try to set up the incremental refresh but even though all is pointing to that query folding should be working, it seems that its not. Please note that I have limited understan...
Data Protection
  • collinsg's avatar
    collinsg
    3 years ago

    Hi Lucas234 

    I think the select statement in the Source line may be the issue. Could you try this...

    let
       Source = Sql.Database("X1", "X2"),
       RunSQL = Value.NativeQuery(Source, "SELECT * FROM [dbo].[X3$Machine Center]", null, [EnableFolding = true] )
    in
       RunSQL

     Hope this helps.

collinsg's avatar
collinsg
Solution Sage
3 years ago

Hi Lucas234 

I think the select statement in the Source line may be the issue. Could you try this...

let
   Source = Sql.Database("X1", "X2"),
   RunSQL = Value.NativeQuery(Source, "SELECT * FROM [dbo].[X3$Machine Center]", null, [EnableFolding = true] )
in
   RunSQL

 Hope this helps.

Lucas234's avatar
Lucas234
Regular Visitor
3 years ago

Great! Thank you very much!!