Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Problems setting up Incremental Refresh

Good morning network,

I need to configure incremental refresh to more efficiently update the data in a report.

I have two folders that store CSV files with measurement data. These files have the same header structure - columns in folder 1, and are also the same as each other in folder 2.

I'm having a problem that I'm not knowing how to solve:

  1. I configure the RangeStart and RangeEnd parameters with type Date/Time

  2. I access in Power Query Editor to the two Queries that I require and filter in both tables the column "0 Date & Time". As you can already see, both columns are categorized as Date and Time. Note: The filter calls the RangeStart and RangeEnd parameters.

  3. When I want to save the changes I constantly get the following error... And I don't know what may be escaping me... "OLE DB and ODBC error: [DataFormat.Error] Unable to parse the input provided as a Date value."

Do you have any idea why this may be due? Without correcting this error I cannot move forward in the process.

Greetings and thanks.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Syndicate_Admin , can you share the error in text format? Also, it showing the filter applied on a different column, that is date type on date type. Check the fx box

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      3 years ago

      Best regards

      • I am not sure what you mean by sharing the error in text format, could you specify a little more please? Additionally, which box do you mean by "check the fx box"?
      • Regarding your observation about the filter: Fixed, now point towards the columa Date - Time the Filters RangeStart and RangeEnd, in both two queries.
      • However, I still get the same mistake:

      THI Armor

      OLE DB or ODBC error: [DataFormat.Error] Unable to parse the input provided as a Date value.

      THI Core

      The upload was canceled due to an error loading a previous table.