Power query pivot returns blank columns when queried files have data

[jmetrooper]

Hi! 

Have uploaded some excel files on power query to do some transformation, however when close and loaded onto power pivot, details of one of the columns returns blank data. 

Example, file has column A- Y, column A contains data starting with text and numeric, has been changed to text data type and not touched in power query. However when pivoted out, column reads as (blank) and only detecting rows that starts with numeric values. 

Is there any way to fix this error?

Thank you!

[jmetrooper]

Hi! Managed to find a temporary solve by creating 3 power queries for 3 files. Realise the issue is pivot not picking up column details from 2nd and 3rd file when combined hence returning blank when doing powerpivot.

Here is a example of how three files are, with same formatting. For instance,  pivot can pick up details from file 1 id column everything from file 1 only, but doesnt include file 2 or 3. 

Thank you!

[v-stephen-msft · Accepted solution]

Hi @jmetrooper ,

Since your three tables have the same columns, have you tried to append them to single table?

Append queries - Power Query | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KNP]

Are you able to paste some sample data and the code from the advanced editor?

(obfuscate any sensitive data)