Power Query Table

[Craigc3814]

I have a query I am running, and I want to put the end result into a table. When I do that PQ keeps adding extra columns to my data that I do not want shown such as Month and Month Index. I do not understand why it is doing this. It is no where to be found in my data when working in the PQ editor, but when I load to a page it gets automatically added.

 

[pabeader]

Sounds like "add related columns' has been checked. Do you see the 'extra' columns in the preview? Do you see ANY extra stuff in the preview?

 

[Craigc3814]

Nope, nothing else in the preview other than what I want. Where is the add related columns box?

 

[pabeader]

I seem to remember that it was at the bottom of the dialog box as I was adding tables to my query. It might actually say "Add related tables"

Are Month and Month index, actual fields in ANY of your tables?

 

[Craigc3814]

No, I think what happened is I initially had this data in a pivot table then realized I didnt like the format and switched to an actual table. Since the pivot table created the extra fields initially they same to have stuck around