Forum Discussion

HR3038511's avatar
HR3038511
Helper I
1 year ago
Solved

Incremental refresh / Query folding with Denodo data source not working

Hi, 

 

I'm trying to set up incremental refresh for a Denodo datasource. I get the following error message:

 

 

I did the following: 

1. Define RangeStart and RangeEnd Parameter in Power Query
2. Pull in my fact table I want to incrementally refresh from Denodo into Power Query

3. Used RangeStart and RangeEnd to filter the date column in my fact table

4. Try to configure the incremental refresh on my fact table but keep getting the error message above

 

My Power Query statement looks like this: 

let
Quelle = Denodo.Contents(Denodo_link, null, []),
vdb_al_plm_Database = Quelle{[Name="vdb_finance_and_controlling",Kind="Database"]}[Data],
vdb_al_plm_Schema = vdb_al_plm_Database{[Name="vdb_finance_and_controlling",Kind="Schema"]}[Data],
#"Run Native Query" = Value.NativeQuery( vdb_al_plm_Database ,"SELECT * from dv_mendix_mtt_accp_reporting_snapimpactdistributionobj ",null,[EnableFolding=true]),
#"Gefilterte Zeilen" = Table.SelectRows(#"Run Native Query", each [changeddate] <= RangeEnd and [changeddate] >= RangeStart)
in
#"Gefilterte Zeilen"

 

Any ideas would be great! Thanks

 

Need Help
  • amitchandak's avatar
    amitchandak
    1 year ago

    HR3038511 , This sometime a warning, so check when it run does it really getting all data, you might have check quesry at source.

    Second you can not have equal to in both

    #"Gefilterte Zeilen" = Table.SelectRows(#"Run Native Query", each [changeddate] < RangeEnd and [changeddate] >= RangeStart)

     

    or push the filter here or create query staring a step before if needed and pass in this query

     

    #"Run Native Query" = Value.NativeQuery( vdb_al_plm_Database ,"SELECT * from dv_mendix_mtt_accp_reporting_snapimpactdistributionobj [changeddate] <=" &  RangeEnd " and [changeddate] >=" & RangeStart & ",null,[EnableFolding=true]),

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    1 year ago

    HR3038511 , This sometime a warning, so check when it run does it really getting all data, you might have check quesry at source.

    Second you can not have equal to in both

    #"Gefilterte Zeilen" = Table.SelectRows(#"Run Native Query", each [changeddate] < RangeEnd and [changeddate] >= RangeStart)

     

    or push the filter here or create query staring a step before if needed and pass in this query

     

    #"Run Native Query" = Value.NativeQuery( vdb_al_plm_Database ,"SELECT * from dv_mendix_mtt_accp_reporting_snapimpactdistributionobj [changeddate] <=" &  RangeEnd " and [changeddate] >=" & RangeStart & ",null,[EnableFolding=true]),