Forum Discussion
SharePoint List Refresh Changing Time to UTC
Hi all, I have developed a set of dashboards from a SharePoint Online List, but I am struggling with some Date/Time issues when refreshing the data in Power BI Service, and I could really use so...
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.
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.