Error message - loading data from folder

Hi enablejulian ,

From what I can see apart from being a different name, they also have a slightly different structure.

This is the step where you most likely have this error (you should have something similar in the template created by PBI):

Table1_Table = Source{[Item="Sheet1",Kind="Sheet"]}[Data]

This works Ok, so I changed it to:

Source{[Item="Sheet12",Kind="Sheet"]}[Data]

This is the error that I get:

Expression.Error: The key didn't match any rows in the table.
Details:
    Key=
        Item=Sheet12
        Kind=Sheet
    Table=[Table]

Looks familiar? 😁

Somewhere in the Query list, you should have something like this. This is the bits that are created by PBI automatically when you do folder import:

On the Sample File try changing the step that is usually called Navigation  and looks like this:

Roll the number in {} from 0 to 2 and check what is happening with the Transform Sample File table, which is the template for the function that PBI generates to import files. If it brakes, you know will find causes it. 

If you have to have different names for tabs in different files (e.g. for csv it is usually defaulting to the file name), let me know there is a way to tweak the code to adapt for it.

Kind regards,

JB