Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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.
@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
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |