Power Query extract specific sheets of the same Excel Workbook

[Fcoatis]

Hello community,

Is there a way to use Power Query to extract only data from the same workbook where all the sheets  names  begin with "rec_" for instance?

Thanks in advance

[MarcelBeug · Accepted solution]

Sure:

let
    Source = Excel.Workbook(File.Contents("<YourPathAndFileName"), null, true),
    #"Filtered Rows" = Table.SelectRows(Source, each [Kind] = "Sheet" and Text.StartsWith([Item], "rec_"))
in
    #"Filtered Rows"

[teylyn]

Hello,

I find that this does not work if the file lives in a OneDrive folder synced to the PC. I works fine with the path

= Excel.Workbook(File.Contents("C:\stuff\Book1.xlsx"), null, true)

but with the path C:\Users\user\OneDrive\Forums\filename.xlsx it throws an error "The process cannot access the file because it is being used by another process."

How can it be made to work for OneDrive stored files?

[Fcoatis]

Thank you