Power Query Folder Option

[Lame]

HI guys,
I am facing issue while using power query. i want to get data from folder and in that folder i have 33 diffrent sheets. But the problem is in all 33 workbooks the sheet name is different and hence power query does not transform all data and shows error. But when i rename all sheets name as same in all 33 workbooks then it works, so how can i solve this issue so do not rename all sheets manually.

 

[Matt Allington]

the M Language has both absolute naming references (default) and relative naming. Go to the sample query and find the step that loads the single page. There will be a step that references the sheet, in part, something like this.
{[Name=“Sheet 1”,Path=“Folder\Sub folder]}
you can consider this as the curly brace being the row, with the Square brace being the filters needed on the columns to uniquely locate that row. You can simulate this by putting filters on the columns when looking at a list of sheets.
simply replace everything in the curly braces with a 0, indicating the first row (assuming it is the first sheet)
{0}