Issue with Power BI Premium License - Date and Time Offset in Published Workspace.

[walterm1989]

Hi community,

I have an issue with my recently upgraded Power BI Premium license. I have enabled the scheduled dataset synchronization option every 30 minutes (Image 01). However, when I try to validate the synchronization, I get the following error.

• The Power BI Desktop automatically filters by the current date and time (Image 02).
• When I publish it to my workspace, everything works fine (Image 03).
• But when I publish it to a Premium workspace, there is a 5-hour offset added (Image 04).

Why is this happening?

As additional information, I am including the calendar table configuration:

• To create the calendar table, I used the following code (Image 05).
• Then, I created a column to get the current date and time, with a condition that shows the previous hour if the minutes are less than 10. This is because the records in the database finish being created at that time (Image 06).
• Finally, I created a condition to validate the calendar date and time with the current date and time (Image 07).

Image 01: synchronization each 30 minutes

Image 02: Dashboar in Power BI Desktop

Image 03: My workspace

Image 04: The premium workspace.

Image 05: query to create the calendar table

Image 06: query to create the current date and time

Image 07: Query to create the condition

Have a great day!!!!