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 finally had my power query working and things were great. I had to make an adjustment and add a column to all of the workbooks I was pulling from. I created a new power query and everything was working fine. Now, once again I missing data from a column. It is not pulling data from all of the workbooks. When I preview the selected workbook the data is there but once I combine it, some data is missing. Any suggestions? I have tried creating individual power queries to see if only using data from 1 workbook would work. It does but that is too cumbersome, as I have 19 workbooks that I am combining.

Answer 2

Hi Terrinbt,

Thanks for writing back to us and letting us know about the result at your end.

As you’re having the problem with specific Excel files, can you please provide the problematic files to us by removing the personal information (to protect your privacy) as it helps us to test at our end.

You can upload the problematic files to your OneDrive and Share us the link to access it.

Thanks,

Chitrahaas

Answer 3

Unfortunately, the company I work for prohibits that. I am unable to share any files with outside entities. Is there another way for you to help me?

Answer 4

Hi Terrinbt,

As we previously tried most possible scenario’s which didn’t help you, we guess that problem could be with Excel workbooks. Have you tried the suggestion provided on 29th January 2019 in private message (copying and pasting to new Excel workbook)? If no, please give a try to it.

Lastly, can you please check whether the same problem occurs with other users in your organization? (Share your files to other users in your organization and check the outcome)

We’re sorry for what you’re facing.

Thanks,

Chitrahaas