Forum Discussion

HenryH's avatar
HenryH
Regular Visitor
10 years ago

SharePoint date differs from Power BI date

Hi,   I have imported data from a SharePoint list into Power BI including one column containing a date. The date in Power BI differs 1 day from the date in SharePoint. e.g. Sharepoint: 1/6/2016 >...
alltasksIT's avatar
alltasksIT
New Member
8 years ago

HI Heny

I am using Power BI Desktop.

 

similar issue

In the query editor  -

right click date column

I changed Type to   date/time/timezone

then I did a 2nd step  -  change type - using localte where I picked   English (Aus)

 

So everything looks great in Power BI desktop - until I publish the report to the Power BI service where the date issues appears again