Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBI doesn't load the right date from Power Query

Hi all,   In my Power Query I have a project showing the Date as 01/08/2020 after all modifications (first parsing date (because somehow it avoided some date errors with other datetime columns) and...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi, finally I found the problem.

    The problem was that the data published on PBI Service didn't refresh properly the date (refreshing every day). 

    So, I did download the lastest PBIX file from the PBI Service, refreshed the data on PBI Desktop, and the date updated. Then I published back the whole data again to PBI Service.

DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Anonymous I find having dates with the timezone part can lead to unwanted results sometimes. Have you tried removing the timezone and working with it instead just as a datetime?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    Thanks for your response. Is not what I did in the first step? In that step, the resulting value is 01/08/2020 with no time or zone. Or maybe you refer to something else?

     

    Thanks.