Can PBI append all the sheets in the same excel file in PBI query?

[Anonymous]

Hi,

I would like to append all the sheets(data formats are the same) in 1 data set but don't want to allocate sharepoint folder to get data for every single sheet. 

Is there any way to get all of them at once? 

[Idrissshatila]

Hello @Anonymous ,

you connect it to power bi and it will show like below then append all these into one

check the append https://learn.microsoft.com/en-us/power-query/append-queries

[Anonymous]

Hi, 

Thanks but actually appending queries is not my question. 

When we get data from sharepoin folder, I hope to get all the sheets at once. 

e.g. sheet #1 from #8 as my initial query snapshot but it seems there is no tick all the sheets at once. 

So currently need to click 'Table' one by one to get the cell values.