The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a CSV file I receive everyday. I need to change the formatting, columns and rows. It is imported to Powerbi with 3 columns that change titles/data daily. How do I make###Top Applications by Session###, ###Top Users by Bandwidth### and ###Top Users by Session### there own table so I can compare data daily?
Current data in CSV file
###Top Applications by Sessions### | ||
ID | Application | Sessions |
1 | HTTPS | 7,414,687 |
2 | fort | 5,235,888 |
3 | DNS | 4,975,238 |
4 | SSL | 3,005,425 |
5 | power | 2,340,469 |
6 | porta; | 2,132,120 |
7 | tc | 1,393,917 |
8 | sn | 815,121 |
9 | micro | 790,143 |
10 | services | 673,252 |
###Top Users by Bandwidth### | ||
ID | User(or IP) | Bytes |
1 | 10.1 | 926.78 GB |
2 | 10.2 | 907.37 GB |
3 | 10.3 | 898.42 GB |
4 | 10.4 | 802.76 GB |
5 | 10.5 | 794.43 GB |
6 | 10.6 | 788.95 GB |
7 | 10.7 | 770.20 GB |
8 | 10.5 | 718.03 GB |
9 | 10.5 | 510.02 GB |
10 | 10.5 | 439.57 GB |
11 | 10.5 | 279.10 GB |
12 | 10.3 | 240.70 GB |
13 | 10.3 | 229.99 GB |
14 | 10.3 | 114.56 GB |
15 | 10.3 | 105.94 GB |
16 | 10.3 | 96.33 GB |
17 | 10.3 | 92.41 GB |
18 | 10.3 | 84.82 GB |
19 | 10.3 | 61.40 GB |
20 | 10.3 | 61.24 GB |
###Top Users by Sessions### | ||
ID | User (or IP) | Sessions |
1 | 100.2 | 875,409 |
2 | 100.3 | 865,993 |
3 | 100.67 | 692,455 |
4 | 100.7 | 440,096 |
5 | 100.6 | 439,862 |
6 | 100.9 | 439,518 |
7 | 100.2 | 309,503 |
8 | 100.2 | 226,421 |
9 | 100.2 | 201,756 |
10 | 100.2 | 172,033 |
@jengnz Use 3 different queries?
How do I create a query capturing the data for just ###Top Application Sessions###? I would need to just get the 12 rows of data.