Forum Discussion

KishNSI's avatar
KishNSI
Frequent Visitor
8 years ago

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, sel...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
8 years ago

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.

 

 

Regards,

Charlie Liao

  • KishNSI's avatar
    KishNSI
    Frequent Visitor
    8 years ago

    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.

  • lso4jw's avatar
    lso4jw
    Frequent Visitor
    6 years ago

    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.