I just ran into a bizarre issue with data not displaying in a table if the columns are sorted a certain way. I have a dataset of three tables, Account, Location, Contact.
They are related like this:
Contact -> Location (Many to Many, bidirectional)
Location -> Account (Many(Location) to One(Account), bidirectional)
If there are no contacts for the account, I still want location and account information to display. I have "Show items with no data" selected. The data from the account and location tables show up in the visual without issue, until the columns for contacts shows up. Any data after this is always blank. However, moving columns to the left of the contacts columns has the data display again.
Filters are not affected, they show the correct data and will filter correctly, but the data they filter in the visual will be blank.
Here are some examples:
Example 1, data missing:
|Name (Account)||Location Name (Location) ||First Name (Contact)||ID (Account) ||Address (Location)|
|Name 1||Location Name 1||(blank, correct) ||blank (incorrect)||blank (incorrect)|
|Name 2||Location Name 2||(blank, correct)||blank (incorrect)||blank (incorrect)|
Example 2, data showing if rearranged:
|Name (Account)||Location Name (Location) ||ID (Account)||Address (Location)||First Name (Contact)|
|Name 1||Location Name 1||ID 1||Address 1||(blank, correct) |
|Name 2||Location Name 2||ID 2||Address 2||(blank, correct)|
If I made a filter to sort by ID 1, it would be available in the filter, but the data would be blank in example 1.
Of course I can just rearrange columns to get my data to display, but I still want to resolve the issue if possible, thanks!