Disappearing Columns

Power Query
1

Hi everyone,

I’ve added a few columns to my data model (nested inside a table) after the original build. The new columns show up in the data view and I’m able to use them in the report. However, they are not in the query editor anywhere.

Is this normal?

2

@cms418,

I’m assuming the columns you’re referring to are DAX calculated columns. If so, yes that’s entirely normal – those will not show up in the query editor.

– Brian

3

No, they are not! They’re columns I added in the excel table.

The model is pointing to a folder rather than a file if that helps at all.

4

@cms418,

Hmmmm… that’s unexpected. Can you please post the file so I can take a look and see what’s going on?

– Brian

5

Hi @cms418,

This can be caused by a number of things, here’s are a few to look out for:

  • If loading Text or CSV files, hard coded number of columns in the Source step
    image
    image798×39 2.58 KB
  • Start by stepping through the “Transform Sample File” query in the Applied Steps pane
    Look for a step that has all hard coded column names like a “Select Columns” for example and update that
  • If still unresolved step through “Query1” (the result query that brings all the data together) and repeat this process…

That should help you resolve it, however should you need further assistance, like Brian mentioned provide a mock up and some sample files that are of the same structure as your production file. So members can better assist you.
Thanks!

1 Like
6

Alright guys, I know what it is. When I originally set this one up I accidently set the source as ‘Sheet’ and NOT table. Spent the afternoon changing the source to ‘Table’ in the Navigation step and voila, everything in the table gets wrapped into the queries.

Everything seems fine now - any potential issues with what I did down the road? RE: Changing the data source at the heart of it all scares me a bit.

-Chris

1 Like