Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incremental refresh with native query in Oracle

I'm pulling in data using the Oracle connector with a sql query.  I've tried looking at many different tutorials to allow incremental refresh with native query and I feel like I'm so close, but I have a sql error now. 

 

Here is my power query: 

I click "Done" and then I can look at the query via the Query Settings and I can see that it grabbed my RangeStart and RangeEnd

But my "Source" produces the following error

What do I fix to get this to work? 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Update:

    I think my issue is date formatting for Oracle.  Currently, my parameters are a Date/Time value. I also added a single quote around the 

     

    & Text.From(startDate) &

     Now, I am getting a different Oracle error message about not a valid month. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Screenshots: 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This worked and I have no errors from SQL. Now the test is if the incremental refresh works.