Dates Not Showing In Incremental refresh settings

[hmbedford]

Hi

I have a dataflow that pulls data from an on prem SQL server via a gateway.

The service wont let me select any of the date columns in the Incremental refresh settings of the dataflow. 

The source has dates available and i have formatted them to date and also tried using locale. i have asked the source system developers to recreate the SQL views to format the dates. 

When i pull the data into my data model in Power BI Desktop the dates appear fine.

I have dropped the images below, has anybody experienced/resolved this issue before?

Thanks

Hayden

[GilbertQ · Accepted solution]

Hi there

The columns have to be Date/Time

Just change the data type to Date/Time and you should then see the field available.

[hmbedford]

Thank you, I cant belive i hadnt tried that!! 

Hayden

[GilbertQ]

No worries, happy to help