Forum Discussion
Power BI Dataset Refresh Succeeds but Specific Timestamp Rows Missing After Refresh
Hi KanchanGiri_121 ,
it seems that some records might have been filtered out.
1) Copy the query for that table and create a new blank query in the desktop file. Select the desired timeframe and check each step to identify where the filtering is occurring.
2) Before performing the first step, verify in the report you are validating whether there are any pre-selected filters that could be blocking the records from being displayed.
3) In Service, the date and time are provided in UTC by default. If you use a function like now(), it will also return time in UTC. If your data is in a different time zone and you are filtering the data based on date time , this could also cause discrepancy
Thanks
Hi Natarajan_M,
Thank you for your suggestion and for taking the time to help.
I’ve reviewed the report thoroughly and don’t see any report-level, page-level, or visual-level filters that would be excluding records. I also checked the query steps in Power Query, and there doesn’t appear to be any explicit filtering removing those rows.
At this point, I’m not able to identify where the discrepancy is occurring. Please let me know if there’s anything specific you’d recommend checking further.