0

I have a list in sharepoint where in create items with date and time amongst other data.

Eg. I have one where I entered the date 14-06-2019 05:00:00

Now when I pull this into Power Bi the date is 14-06-2019 12:00:00

I have been looking into time zones, but can't quite figure out how to change it.

I don't have admin rights to the SharePoint site, so I can't do anything about the time zone there.

0

Power BI is pulling the data as UTC.

enter image description here

You can confirm this if you go to 'Edit Query' in your Power BI file and change the type of the date column to Date/Time/Timezone, which will show you the timezone offset settings for the date as well.

enter image description here

Now, you can duplicate this 'Date/Time/Timezone' column to create a new one and then use same 'Change Type' option to select the last option 'Using Locale', which would open the form to select your 'Locale' and then transform the date according to that Locale.

enter image description here

enter image description here

After applying the changes, 'Modified Date' is showing value in my current Locale:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.