Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data table visual not synced with underlying dataset

I have an underlying dataset which is a direct query to a SQL server table.  The most current entry is 8/17/2023 3:16:16 PM , nevermind the nulls in the screens shot.

 Then in the data table visual I have attached to this table, the most current entry is 8/17/2023 2:46:16 PM.  

I'm not sure why the data table visual is not saying the same thing as the underlying data table.  

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    No, there is no filter.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi Anonymous ,

    According to your description, it seems like you are experiencing a discrepancy in the data table visual in Power BI. There could be several possible reasons for this issue, such as:

    • The data table visual is not refreshed after the underlying data is updated. You can try to refresh the visual manually or set up a refresh schedule for your dataset.
    • The data table visual is using a different time zone or format than the underlying data. You can check the regional settings for your dataset and report and make sure they are consistent.
    • The data table visual is using a measure that has a different logic or calculation than the underlying data. You can check the DAX formula for your measure and see if it matches your expected results.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I manually refreshed the visual and the visual still wasn't showing what's in the underlying data table.  The underlying data table is using a direct query to an SQL server table, and I have it to only show the latest record based on the latest datetime.  In the query editor you can filter on the datetime column to just show the latest datetime.  For some reason this is not making its way back to the visual.