Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have the following csv:
A,B,C,D
2017-09-29 00:00:00,OMEGA ,AB ,19
2017-09-29 00:00:00,OMEGA ,AB ,20
2017-09-29 00:00:00,OMEGA ,AB ,22
2017-09-29 00:00:00,OMEGA ,AB ,19
2017-09-29 00:00:00,OMEGA ,AB ,19
2017-09-29 00:00:00,OMEGA ,AB ,19
If I create a table in a report it will look like this:
Is there any way for me to see all the rows (even the duplicate ones) and how do I do if I want to export them?
Best regards,
Mattias
Solved! Go to Solution.
@Matjo add an index to the line, ie add column / index column in power query , that will make each line unique then add the index to your table visual table
or you could add a group by or count column to tell you how many rows there are of the same. so add a measure countrows(tablename) and then add the measure to the table that tells you how many you have of each row
Proud to be a Super User!
@Matjo add an index to the line, ie add column / index column in power query , that will make each line unique then add the index to your table visual table
or you could add a group by or count column to tell you how many rows there are of the same. so add a measure countrows(tablename) and then add the measure to the table that tells you how many you have of each row
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
133 | |
76 | |
53 | |
38 | |
37 |
User | Count |
---|---|
202 | |
80 | |
71 | |
55 | |
48 |