Forum Discussion
maracles
10 years agoResolver II
Last Updated Tile - Time mismatch from Power BI.
I have followed this video to create a "Last Updated" tile for my users (rather than adding 'Refresh' time on each tile. Create Impactful Reports with Power BI Desktop Basically, the steps are...
hopey
10 years agoFrequent Visitor
I have same problem. I use local time to show the measurement results. When I try Power BI website to show the last result by asking question for example "last fifteen minutes". It shows results 3h earlier, which happens to be the difference between utc and local time.
I need to ship this to customer now and try to explain why it doesn't work :(
I have also tried query at stream analytics, but no luck:
SELECT HumDHT22_1,
LAST(HumDHT22_1) OVER (PARTITION BY HumDHT22_1 LIMIT DURATION(minute, 15) WHEN HumDHT22_1 IS NOT NULL)
INTO
[ncc01latest]
FROM
[IoTHubStream] TIMESTAMP BY timecreated
WHERE
[ObjectType] IS NULL -- Filter out device info and command responses