Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In one of the appended tables I created on the query editor side, I noticed that there is a significant amount of rows/records that are missing. Of the 7 files that make up the appended table, 5 of the files contain approx 24,000 rows of data, and 1 file contains just over 14,000 rows. Only 1 other file of the 7 loads all 24,778 rows without issue. However, when closing the query editor and going to the Data tab in the report view, it only shows 63,670 rows. The strange thing is that there was no issue with the first 6 files when I was working on some updates to the report last Thursday.
There is no filter being applied on the query editor side, so there would be no reason as to why the data/report view would not load all rows. I don't believe there is anything wrong with the relationships between tables that would cause the overall data for the table to be excluded. Please help.
Thanks,
Sean
Solved! Go to Solution.
I found the issue. The relationship had defaulted to 'one to one', but when I changed it to 'many to one', all of the expected rows showed.
-Sean
I found the issue. The relationship had defaulted to 'one to one', but when I changed it to 'many to one', all of the expected rows showed.
-Sean
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |