Data table visual not synced with underlying dataset

[Anonymous]

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.  

[v-yanjiang-msft]

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]

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.  

[Anonymous]

No, there is no filter.

[Idrissshatila]

Hello @Anonymous ,

can you check if there's any filter that is affecting the visual and try to refresh .

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡