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: 983
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 Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

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: 983
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 Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

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