Forum Discussion
AkshayShingan
5 years agoRegular Visitor
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 havi...
- 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
Anand24
5 years agoSuper User
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 !!! |