Forum Discussion

troyhimes's avatar
troyhimes
Resolver I
2 years ago

DB2, Incremental Refresh, Query Folding Basics

Hello, I am querying a DB2 db but fails every so often due to a time out error.  I've never used incremental refresh but understand that this would probably be a solution and that query folding is r...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi troyhimes 

Thanks for your quick reply.  After testing, the source step itself is not collapsible, it only acts as a connector to connect to the data source, but in order to ensure that the later steps can be collapsed， you can refer to the following steps:

1.Make sure that your connect mode is import, don't filter in advanced options. just click ok

 

2.Select the database , then click 'Transform data'

 

3.Add a new step in power query , then refer to the following code.

 

= Value.NativeQuery(xxxx(your database name),"select * from SQLTest",null,[EnableFolding=true])

 

Then you can find the query folding can use.

And you can refer to the following video.

Bing Videos

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

troyhimes's avatar
troyhimes
Resolver I
2 years ago

Thanks Yolo (@v-xinruzhu-msft ), we're getting close.  I had previously watched that video too but couldn't get it to work.  I believe it may be something simple in the way I'm writing the command.  Do you see anything that may be causing the issue?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi troyhimes 

    Thanks for your quick reply, based on the picture you have offered,

    You need to enter the database first, you can refer to the step I offered above.

    Then you don't need to use " " for the database name, try this.

     

    Value.NativeQuery(FXXD,"select * from jdeview",null,[EnableFolding=true])

     

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • troyhimes's avatar
      troyhimes
      Resolver I
      2 years ago

      Yolo ( Anonymous ),

      1. One difference on the 'Source' step betwen mine (Db2) and your example (SQL) is that the database name is required in the first step for Db2 source vs a SQL source.

       

      2.  With that in mind, here's how it goes down for me.... tried it a couple different ways, but it ends with an error either way

      Try #1

      Try #2