Incremental refresh Issue

[Ax]

Hi Guys 

I  am trying to use incremental refresh and followed all the steps in my model. I could refresh the power BI file in desktop however it is not being refreshed at power bi online and showing below error. 

I chekced my gateways etc all working fine, if I remove the incremental step i can refresh it. So issue is coming from incremental refresh steps. Here is the error message :-

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The column '1/06/2018' of the table wasn't found."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"1/06/2018"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 9fa609f0-964e-4d82-bc7b-746d437e692b
Request ID: 24dff524-8ce6-10c3-b81f-300d79caf7d8
Time: 2020-03-25 23:08:56Z

[Anonymous]

Hello, I hit a similar error. Did you fix it?

[Greg_Deckler]

This seems to be the key bit:

The column '1/06/2018' of the table wasn't found.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Ax]

Thanks Greg 

There were two excel file that has some budget information with dates as column. I deleted those file to test. Now incremental refresh is working.

However, all model including those excel file works seamlessly in BI desktop. 

It seems some formatting of those dates causing issues in incremental refesh on BI service.