Forum Discussion

Afshin's avatar
Afshin
Frequent Visitor
3 years ago

PowerBI desktop default Timezone?

Hi,

 

I am using PowerBI desktop. I have seen forums/blog posts about the issue with powerbi service. But my problem is with powerbi desktop. I have some parquet files coming from data lake processed by databricks, the timezone for that is set to local time /BST and  I have verified the datetime column in the tables there that the time is accurate

 

However, when I load those files into powerbi the time values seem to go back one hour. It looks like powerbi desktop is using UTC and not BST.

the datetime column is formatted like this mm/dd/yyyy hh:mm:ss AM/PM

 

What are the default timezone settings for powerbi desktop? and How can I make it use the local time? (to account for the daylight savings change  that happens in the UK)? 

 

No RepliesBe the first to reply