Forum Discussion
Helper VPower Bi service refresh returns blank table
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)))
Super UserDid you filter on date/datetime using a volatile formula -today(), DateTime.LocalNow, etc? The services uses UTC so today your timezone maybe different the service's.
Hussein_charifHi danextian,
no i dont have any measure using Today() function, basically the table just returns all blanks when i check it in the service, then when i refresh again in service it fills to a certain date, then refersh again, then fills a bit more... until the whole table is filled with the most recent data. could it be something related to the data gateway it is connected to?
- danextian
how about filtering from the query itself? Anything that filters a date/datetime column?
- Hussein_charif
yes there is a date filter, speaking of that when its refereshed the dates are blank and when i try to navigate with the date slicer (it's a between type), the dates that were highlited in black and can be navigated to become unusable, meaning i cannot press on that date again as if it doesnt exist in the table