Date Format

Any topic that doesn't fit in elsewhere
Steve_D
Posts: 52
Joined: Sun Jul 31, 2016 2:29 pm

Date Format

Postby Steve_D » Fri Aug 05, 2016 6:51 pm

Anyone else had a problem with the date format converting dates from Std Au format of dd/mm/yy to US format of mm/dd/yy when parsing dates between power Pivot and Power BI?

MattAllington
Posts: 898
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Date Format

Postby MattAllington » Sun Aug 07, 2016 12:38 pm

Never seen this. Is it when you import a power pivot workbook into Power BI? Do you have the format set in the source workbook? I also assume your regional settings are correct, right?
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

Steve_D
Posts: 52
Joined: Sun Jul 31, 2016 2:29 pm

Re: Date Format

Postby Steve_D » Sun Aug 07, 2016 5:54 pm

Yep, power query has it in DD/MM/YY format, imports into PowerPivot in DD/MM/YY format but when i import into Power BI it changes to MM/DD/YY format.

MattAllington
Posts: 898
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Date Format

Postby MattAllington » Mon Aug 08, 2016 8:33 pm

I suggest you post this one at community.powerbi.com. There are MS staff that monitor that forum and this could be a bug.
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

Steve_D
Posts: 52
Joined: Sun Jul 31, 2016 2:29 pm

Re: Date Format

Postby Steve_D » Tue Aug 09, 2016 6:52 pm

will do. thanks.


Return to “General”

Who is online

Users browsing this forum: No registered users and 1 guest