Forum Discussion
Power query pivot returns blank columns when queried files have data
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.
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!
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.