cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KishNSI Frequent Visitor
Frequent Visitor

Columns are not getting pulled through

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?

 

 

Columns.PNG

 

 

2 REPLIES 2
Moderator v-caliao-msft
Moderator

Re: Columns are not getting pulled through

@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 ( Expand column icon ) in the column header.

 Capture.PNG

 

Regards,

Charlie Liao

KishNSI Frequent Visitor
Frequent Visitor

Re: Columns are not getting pulled through

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.