Forum Discussion
Power BI Service - Dataset Date Changing
Hi All,
I am experiencing an issue where powerbi service on scheduled refresh, modifies the datasource date which I am assuming is reverting it to UTC. This however only happens to one of the tables in my model. Is there a way to stop powerbi service from doing this?
As an example:
The data is coming from an Odata feed and looks like the below.
Within PowerBI Desktop it comes through and is displayed correctly:
However issue with powerbi service where it takes a day off:
Clicking the data source and selecting the table:
Creating a table using the dataset in Power BI Service:
Within powerbi about I have confirmed that the timezone of powerBI service is also GMT+1000 and the data stored is within australia (same timezone too). I have also set my browser language to english australia in hopes that would fix it.
Any help or suggesstions would be greatly appreciated
You need to keep these fields as DateTimeZone throughout all of Power Query. Only change to Date format in the Power BI visuals (not in the data model)
1 Reply
You need to keep these fields as DateTimeZone throughout all of Power Query. Only change to Date format in the Power BI visuals (not in the data model)