Forum Discussion
Solved
Power query pivot returns blank columns when queried files have data
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 ...
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
Super User
Super UserAre you able to paste some sample data and the code from the advanced editor?
(obfuscate any sensitive data)