Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, When I make a combination of queries, between two databases I use the inner join, it brings the correct number of rows until I make the filter in the new column, after this step, the number of rows is increased in the wrong way, how can I solve this error.
tks for u help.
Cristian.
Solved! Go to Solution.
Without some sample data this is hard to debug.
If you're looking at this in PowerQuery, please keep in mind that only the first 1000 rows are being loaded per time. If your combined dataset is larger than that, then there's a chance that you're not seeing the full results before filtering (and again, the rows that you see in PowerQuery might again look slightly different when you load them into PowerBI).
Also, with inner joins, check that the column that you are joining on is UNIQUE. If there is a duplicate in either of the original datasets, then your joined table will also have a duplicate row. It's strange to me that the number of rows increases after filtering, rather than joining / expanding the columns, so maybe you need to take another look at your source tables. Good luck.
Without some sample data this is hard to debug.
If you're looking at this in PowerQuery, please keep in mind that only the first 1000 rows are being loaded per time. If your combined dataset is larger than that, then there's a chance that you're not seeing the full results before filtering (and again, the rows that you see in PowerQuery might again look slightly different when you load them into PowerBI).
Also, with inner joins, check that the column that you are joining on is UNIQUE. If there is a duplicate in either of the original datasets, then your joined table will also have a duplicate row. It's strange to me that the number of rows increases after filtering, rather than joining / expanding the columns, so maybe you need to take another look at your source tables. Good luck.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |