cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RNooijen
Helper I
Helper I

Date data/datetype changes on refresh in PowerBI service

Hi all,

 

I have a situation where I need some help with, I hope someone has a solution for it.

 

I have created a report based on a date type DD-MM-YYYY.


Sidenote:
and change this to a different format "WK"&

WEEKNUM('dDate Report'[Date],21)&
FORMAT('dDate Report'[Date],"YY") which gives me for example WK 01 2021.
 
When I create my column chart on the PowerBI desktop I get the result below, which is correct.
desktop data.PNG
 
When I publish my report on PowerBI service then it still shows the same/ the correct way.
But when I refresh my report in PowerBI service it somehow changes date types and some dates get "shuffled" as bellow:
Web data.PNG
Here you can see that week 5,6&9 are gone and week 40 and 41 have much greater value, so it looks like week 5 & 6 or 9 are added to week 40 and 41..

To investigate my issue I have added a date filter to my report to check how the dates are calculated:
 datefields.PNG

What I can see is that dates like 19-2, 26-2,19-3 and 26-3 are correct, and 5-2,5-3,12-2 and 12-3 are "shuffled" during the refresh in the PowerBI service.

Anyone have a clue how this is possible/ how I can solve this?
 
Thank you in advance!
 
Kind Regards,
Ramon
 
1 ACCEPTED SOLUTION
RNooijen
Helper I
Helper I

I solved my issue....

From PowerQuery I had transported the date as a text value and transformed the text value to a date in PowerBi desktop. which caused that in some cases the day and month where swapped.

Right now I have set the field type to date in PowerQuery and my issue is solved.

 

Kind Regards,

Ramon

View solution in original post

3 REPLIES 3
RNooijen
Helper I
Helper I

I solved my issue....

From PowerQuery I had transported the date as a text value and transformed the text value to a date in PowerBi desktop. which caused that in some cases the day and month where swapped.

Right now I have set the field type to date in PowerQuery and my issue is solved.

 

Kind Regards,

Ramon

RNooijen
Helper I
Helper I

@amitchandak ,

Thank you for your fast response, I have checked the link and tried to setup de right settings. But it didn't solve my issue:
I have checked the PowerBi service setting its on Default (browser language)
The Chrome settings are on Englisch (UK) which should have DD/MM/YYYY
And I have cleared cache and published/ tried again.

Any other ideas?
See images bellow:

UK language chrome.PNGcache.PNGPBI lang settings.PNG

amitchandak
Super User
Super User

@RNooijen , Have you changed any date setting like -https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/

 

Also, Clear cache and try again

or

Republish, clear browser cache, refresh and check



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors