October 21, 2018
I am new to Power Query and I am pretty sure this question was made one thousand times but I really cant find the answer...
So I imported Sheets from a folder and I get an error. I already now the problem, the Rows are changing from file to file. Therefore I presume there is a problem with the matching of the data.
I unfortunately cant anticipate in which file the rows are changing. There are no false data, just sometimes more detailed.
From a user perspective I could imagne a functionality that says something like "Expand rows to all" or something like that. The best solution would be to keep all the rows, the next best to keep all identical rows.
Can someone give me an advice how to handle this?
Thank you for your time.
October 18, 2018
Your request is too vague to be able to offer you a solution. Could you please upload a sample worksheet that you are having issues with, and explain in detail what the issue is with the particular workbook. Also, explain in detail what you wish to happen with the sample workbook and show (mocked up manually) what you want the result to look like. With this information, we can provide you with a solution that should work for you.
October 18, 2018
Power Query only pulls in the first 200 (or so) rows to decide how to filter your data. When you pull in an entire folder of data, the first file in is used for deciding what your data looks like. I thought I read in the latest Excel 365 update, you could specify which file would be first (used to decide). If you could change down your list of files in the folder, you might be able to locate the one where you are throwing that error. It seems this topic has many more suggestions on the official MSFT site at:
There are two or three suggestions on the above link, including insuring the correct case spelling of the files being included.
I hope this helps.