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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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...?
| User | Count |
|---|---|
| 23 | |
| 19 | |
| 18 | |
| 17 | |
| 10 |
| User | Count |
|---|---|
| 54 | |
| 53 | |
| 42 | |
| 38 | |
| 32 |