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.