I have a Direct Query table pulled from SAP Hana via SQL (due to a join). It is not connected to any other table in my document. There are no calculated calolmns. Every row in Fields 1, 2, and 3 have a value by definition. I can confirm this when I look at the data preview. Also, when just the first 2 fields are present, the table shows that there are values in both fields.
I am using the standard, built-in Table Visual. I have not changed any of the settings- it is set to 100% default.
When I add the 3rd field, all except one row from Fields 1 +2 disappear. When I use the filter to randomly add some back in, there is always only 1 row that shows as non-blank in Field 1 and 2, even though there is a placeholder for them. Sometimes, it updates to the newest value added, sometimes not. It's pretty inconsistent.
This behavior doesn't make any sense and I can't figure out what is going on here. Any thoughts?