Power BI Service - Dataset Date Changing

[lberkhout]

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

[lbendlin · Accepted solution]

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)