Forum Discussion

harryli's avatar
harryli
Helper II
4 years ago

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

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:

 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      harryli
      Helper II
      4 years ago

      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)

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.