Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

tebones

Dataflow (preview) - dd.mm.yyyy becomes mm.dd.yyyy when consuming data in PBI Desktop

Submitted by Advocate II on ‎11-08-2018 01:02 AM

Hi, I am trying dataflows for the first time. Greate feautre by the way! Here is my issue:

 

When creating an entity in dataflow all looks well:

 

image.png


Note the dateformat is dd.mm.yyyy.

 

When trying to consume the same data fra PBI Desktop the date is changed to mm.dd.yyyy and the import is not correct.

 

This is the same data in Power BI Desktop:

 

image.png

 

Note that SID 02/101 has swapped the dd with mm, and that SID 02/1015 failes because month 18 don't exists.

 

I guess this is a locale/language issue, but I cant find out where to change it.

 

Pls advice!

BR
Trond Erik Bones

Status: New
See more ideas labeled with:
35 Comments (35 New)
Comments
dcresp
Advocate IV
Advocate IV
‎05-07-2019 07:46 AM

Any update on this it still seems to be an issue. Power BI Service Dataflows are converting the date to the wrong format.

PaulKn
Advocate II
Advocate II
‎05-07-2019 11:47 PM

@dcresp I'm not personally experiencing this issue anymore. UK dates retrieved through a gateway have been coming through fine for me using the English United Kingdom locale since approximately 12th April.

tebones
Advocate II
Advocate II
‎05-07-2019 11:52 PM

@dcresp The same goes for me. This has been working for the last few months with Norwegain locale.

Alex_Rajkov
Advocate III
Advocate III
‎08-13-2019 04:49 AM

Same issue with german input dates. DD-MM-YYYY. Source (MS NAV 13 ODATA webservice) is connected via current gateway. Everything is set to german region / language.

Till last friday I had to set the culture in the dataflows to englisch-USA. That stopped working. Any combination - switch culture for dataflows, set different input date locales while converting the text into datetime failes while refreshing. Even though the preview and saving the dataflow looks good.

This is a mess and has to be fixed this week, since dataflows aren't a preview feature anymore. Many of us have transferred the business logic to the dataflows and now can't rely on it.

😞

pat_mecee
Frequent Visitor
‎10-11-2019 02:58 PM

Issue remains unresolved in dataflows converting text dates of format YYYY-MM-DD or DD/MM/YYYY to the date format configured for English (Australia) locale. All data sources are configured in Sharepoint online and On-prem data gateway as Australian locale. The dataflow does not show any error on the datatype conversion step (perhaps dates within the row preview range are OK) but a column sort by date appears to force the error. All scheduled dataflow refreshs are failing. Ticket is lodged with MS support.

Idea Statuses