Power Query not showing all the cell data

Question

I have combined 35 workbooks using the new get data feature. I have these workbooks in a folder.  Each workbook has the same column names. When I combine the workbooks in power query I am getting "null" in some of the cells where there is text in the original workbook. Any idea why this is happening and how to fix it?

Answer 1

I appreciate you trying to help. I am not sure how I I am supposed to send you the zip files. I don't have your email address? Am I missing something? There isn't a way to insert files through this.

Answer 2

Hi

That was in my previous reply ==> see How To here if you want to do it with OneDrive

Once you have copied the link just paste it in your next reply

Answer 3

Hi Terrinbt,

Thanks for writing back and we’re sorry for delay response.

We can understand the inconvenience caused by it,  to narrow down the problem, can you please provide three workbooks (original workbooks and two others causing the problem) via private message (to protect your personal information). Steps for uploading the files are provided in private message.

Note: If you think workbooks doesn’t contain any personal information, you can also share the link in thread, that which makes a way to Lz. (Volunteer Moderator) to help you.

@Lz., thanks for helping the members in this community.

Regards,

Chitrahaas

Answer 4

Hi Terrinbt,

To move further regarding this issue, please provide the information asked in the above reply.

Regards,

Chitrahaas

Answer 5

Obvioulsy we won't know the end of that story...

Only thing we can reasonably assume => not a product issue (might help others facing a similar challenge)