Columns are not getting pulled through

[KishNSI]

I'm getting a confusing result from my connection to our Connectwise database that is dramatically interfering with my ability to pull information. I'm pulling in a table that should be a normal, self-contained table, and it is displaying some columns like this. The database information says this is not a view or anything that should be referencing another table like this. Why would values not be getting pulled in here? Am I missing something obvious?

[v-caliao-msft]

@KishNSI,

In Microsoft Power Query, we use the Expand operation to bring related tables back together. Complex columns that can be expanded to expose the inner elements have an expand icon (  ) in the column header.

 

Regards,

Charlie Liao

[lso4jw]

This isn't a solution. Furthermore,  my CSV file will have the column, but when I did the expand command it doesn't show up. If I type it into the command it will pull it in, but with NULL values. For me, this only started with the June 2020 update.

[KishNSI]

y confusionM is that these shouldn't be merged tables, these should be fields that are part of the base table I'm using, at least according to the documentation I have. And while the data shows up fine when I try to pull it out in a report, expanding the table doesn't seem to work right, it just grabs this unrelated table's worth of fields and populates it with nulls. Because of that, I can't do any joins like this to get data organized in a way that I can set up certain visuals properly separated by categories.

Maybe this is a problem with the database, but I've just never seen it before. 

EDIT: Ok, it's pulling the data through now. Still a mystery to me as to why it's behaving this way, but at least I can work with the data now.