Forum Discussion
SharePoint List Refresh Changing Time to UTC
I can confirm that all the Power BI Servers are set to UCT, and what happens is if you are using the DateTime in your query to get it from the local server (which in this case will be the Power BI Servers) it will always be UTC.
I have a blog post explaining the details, as well as how to overcome this by setting your timezone into the Power Query Editor
Hello GilbertQ,
I appreciate your reply, however I don't quite understand how the solution in your blog applies to the scenario I outlined in my initial post; maybe my understanding is incomplete. You confirm the Power BI servers have a default UTC paramter, but it's not necessarily clear how I address the issue within my dataset.
After following the steps in your linked post, I followed on to your Daylight Savings Time post, but it's not clear which query I should amend the M within, and when I attempt to do so in my base Sharepoint Online table I am left with no EOF and the added language doesn't apply.
- Hi there, sorry for the confusion.
What I was trying to show you, is that you will need to modify your date time column in your dataset to reflect the timezone that you are in. So that when Power BI refreshes the dataset, it will then apply the correct timezone so that the dates and times appear correct on the reports.