cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marek123
New Member

Incremental refresh date as char

Hi All, I am configuring incremental refresh according to documentation https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

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

Greetings

Marek

3 REPLIES 3
Fowmy
Super User IV
Super User IV

@marek123 

You can refer io this video: https://guyinacube.com/2020/07/08/incremental-refresh-with-integers-in-power-bi/

________________________

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
amitchandak
Super User IV
Super User IV

@marek123 , You have date in database or datekey?

 

Refer if this can help:https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-...



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!

Hi,

in the databse the date column is as following:

marek123_0-1602059308853.png

marek123_1-1602059320378.png

Thank you in advance for your help!

Helpful resources

Announcements
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!

secondImage

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.