Forum Discussion
Solved
Power Bi service refresh returns blank table
i have a report published on pbi service with around 10 tables. at a specific scheduled refresh time in the morning, when the scheduled refresh finishes, 1 of those 10 tables which contains the main ...
If you're able to refresh correctly in desktop but getting no rows in the service depending on when the refreshe is made, then it is a timezone difference between yours and the service's. You need to take into consideration when using volatile functions like today(), now and the M equivalents the timezone difference.
The formula below returns the current utc time and adds 8 hours, +8 being my UTC offset, and then parses the date only.
INT ( UTCNOW () + DIVIDE ( 8, 24 ) )Below is the M equivalent. Notice the need to remove the timezone prior to parsing the date as there is a bug in the service that still returns the UTC equivalent if TZ is not removed.
Date.From(DateTime.From(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()) + #duration(0,8,0,0)))
Can you please provide whether data fetching from data flow or directly from server?