Forum Discussion

AkshayShingan's avatar
AkshayShingan
Regular Visitor
5 years ago
Solved

incorrect Date in PowerBI

Dear Folks,

I am working on a Solution which involves PowerBI, Sharepoint as data source and Powerapps as a data input app.

My data source (Sharepoint list) has a Date Column

The problem I am having is while I update a Date in my Sharepoint list.

 

Example

Powerapps - Date input is 1 June 2021 

Sharepoint - Date shows 1 June 2021 (perfectly fine)

PoweBi Online report in my Workspace - Date shows 31 May 2021 (incorrect)

 

I am not able to understand why it shows me one day less than expected. I searched online and found that it has to do with the timezone but I have no clue how PowerBi Service sets its timezone and how to change it.

Only thing currently I feel is my Sharepoint and Powerapps have a correct timezone and PowerBi Service has some other.

Need to fix this.

 

Your help is truly appreciated.

Thanks alot

Need Help
  • Anand24's avatar
    Anand24
    5 years ago

    Hi AkshayShingan ,

    Power BI Services automatically converts all the date/datetime to UTC timezone. Hence, what you are getting is expected.

    You will have to create a new date measure/column to convert the timezone to required one and then use this date everywhere.

    For example: Datetime+5.5 hours=IST timezone

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn

2 Replies