Problems setting up Incremental Refresh

[Syndicate_Admin]

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.

[amitchandak]

@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]

Regards network,

Could someone help me on this issue?

Thanks a lot!

[Syndicate_Admin]

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.