Page 1 of 1

Date Format

Posted: Fri Aug 05, 2016 6:51 pm
by Steve_D
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?

Re: Date Format

Posted: Sun Aug 07, 2016 12:38 pm
by MattAllington
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?

Re: Date Format

Posted: Sun Aug 07, 2016 5:54 pm
by Steve_D
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.

Re: Date Format

Posted: Mon Aug 08, 2016 8:33 pm
by MattAllington
I suggest you post this one at community.powerbi.com. There are MS staff that monitor that forum and this could be a bug.

Re: Date Format

Posted: Tue Aug 09, 2016 6:52 pm
by Steve_D
will do. thanks.