Showing results for 
Search instead for 
Did you mean: 
New Member

Incremental refresh date as char

Hi All, I am configuring incremental refresh according to documentation

The difference here is that our databases have the dates in the formats of YYYY-MM-DD HH:MM:SS as char data types. The hint in the document mentions to place this query in the filter step to convert to an integer: (x as datetime) => Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x)

I am confused how to convert the parameters to fit them to my database.

Thank you in advance



Super User IV
Super User IV


You can refer io this video:


If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn
Super User IV
Super User IV

@marek123 , You have date in database or datekey?


Refer if this can help:

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!


in the databse the date column is as following:



Thank you in advance for your help!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.