Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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)
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)