Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi I'm working with a large data set that captures data constantly. I am wondering how to go about filtering the data to only show 2 samples per second instead of every sample that I get in that second?
I am monitoring the data 24/7 so it is always bringing in new information. I want to condense that information as much as possible.
Thank you!
@Anonymous If the data is in a relational database eg: SQL Server, then write a custom SQL Query while importing to filter the records (sample 2 records) per second by using RANK. Otherwise, you can also create a new calculated rank column in PBI itself. Anyway, sample data and expected output will help us to understand more details to suggest an accurate solution.
Proud to be a PBI Community Champion
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 25 |
| User | Count |
|---|---|
| 124 | |
| 87 | |
| 70 | |
| 66 | |
| 65 |