Forum Discussion
CSV file in PowerBI
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 |
2 Replies
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.
