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)))
Helper Vyes 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
Super UserIf 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)))
- Hussein_charif
thank you danextian, i'll work on the scheduled refreshes to make sure they aren't interrupted by a refresh from the server then