Forum Discussion
KanchanGiri_121
6 months agoFrequent Visitor
Power BI Dataset Refresh Succeeds but Specific Timestamp Rows Missing After Refresh
Hi, I’m facing a strange issue with a Power BI dataset refresh and wanted to check if anyone has seen something similar. The dataset is set up with scheduled refresh in Power BI Service, and the re...
Natarajan_M
6 months agoSuper User
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