Missing column when creating a pivot with 2 tables

Question

I want to create a pivot with 2 tables. But the problem is, 1 column from the table is missing in PivotTable Fields.

This is my table, it has Channel, Store, Concept, Status, Stock Sync, and **Fulfilment Type.**This table is generated from MySQL odbc.

When I try to pivot it, nothing odd happens

But when I try to add a table with More Tables function, my Channel column is suddenly missing from the PivotTable fields and the data is changed with Store.

Is there something wrong with my step? Please help.

Answer 1

Copy/paste of info from hilmandenis in Slicer Cant Connect To 1 Pivot Table where

Question was: should I understand that the Missing columns in Pivot is no longer an issue?

Answer: Yes, I just use a range instead of the table itself, so I can get the Channel column that missing

Answer 2

Hi

Let me set some expectations 1st:

• I'm not at all an expert of Pivot Tables
• I don't have MySQL

All this to say I won't necessarily be in the best position to help solves this problem... 

#1 1st thing that is obvious to me from your pictures: your 2 Tables have common columns names, so even if I'm not 100% this is the root cause of your problem, it could be...

#2 You say your Table comes from MySQL but you actually "play" with 2 Tables. Where does the 2nd Table come from/where is is stored?

#3 Is there any relationship established between the 2 Tables (I don't think so but given what I said in intro…)? If so, on which field(s)?

#4 If no relationship is established between the 2 Tables, does one have field (i.e. [Store] with UNIQUE "values" that match in the other Table? 

#5 Is there anything (in other words Table(s)) loaded to the Data Model (Power Pivot)?