Forum Discussion

hmbedford's avatar
hmbedford
Frequent Visitor
5 years ago
Solved

Dates Not Showing In Incremental refresh settings

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

 

 

  • 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.

3 Replies

  • 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.