The interface data didn't not match with Power Query Editor

[harryli]

The Power Query Editor is like the following and I filter the 28/7/2022(by the day filter of today and tomorrow)

But the power bi interface result is different from the Power Query Editor data, I suppose the interface is showing the Power Query Editor data directly, but there isn't. Please for help.

The interface like below:

[v-xiaotang]

Hi @harryli 

Thanks for reaching out to us.

>> But the power bi interface result is different from the Power Query Editor data

Did you click close&apply after setting the filter? after I click this button to go back to the Desktop interface, the data is updated.

My Power BI Desktop version is 2.107.841.0 64-bit (July 2022)

Connection mode: Import

If you have done the same, but the data in the Desktop interface is not updated, please try to click refresh

Or go to Power Query and click close&apply again.

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@harryli , Power quey only shows 1000 rows, are you sure these dates are wrong? Also filter date should be preferred on truncated date - date with no timestamp

[harryli]

there is only has 7 data in power query editor with 29/7/2022, but I dont know why it keeps yesterday data(28/7/2022)