Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
How to display only the latest data on a report?
I have a hybrid table, import + latest data (direct query premium). Is there any way to display only the data with the most recent update date?
Even when I do something in DAX the report in portal will not load so much it takes so long....
Here the problem is that it is a hybrid table and I already have X data, but during filtering I download the latest data via direct query and in the previous data I had X, but in the new data is already updated and there is again X only for example from a different time.
You could use something like Max function in dax...?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 28 | |
| 23 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 44 | |
| 32 | |
| 18 | |
| 17 | |
| 17 |