let
Source = SharePoint.Files(Web.Contents("https://[site].sharepoint.com/sites/ITLeadership"), null, true),
#"Filtered Rows" = Table.SelectRows(Source,each ([Folder Path] = "https://[site].sharepoint.com/sites/ProjectITLeadership/_layouts")),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Active Projects - 48", type text}, {"Computer Users", Int64.Type}, {"Project IT Staff", Int64.Type}, {"""AS Sold"" Project Cost", Int64.Type}, {"Project IT Budgets Current IT Spend of all Projects", Int64.Type}, {"Current IT Spend of all Projects", Int64.Type}, {"Column7", type text}, {"Column8", type any}, {"Column9", type any}, {"Column10", type text}, {"Column11", type any}}),
#"Kept First Rows" = Table.FirstN(#"Changed Type", each [#"Active Projects - 48"] <> null),
#"Removed Other Columns" = Table.SelectColumns(#"Kept First Rows",{"Active Projects - 48", "Computer Users", "Project IT Staff", """AS Sold"" Project Cost", "Project IT Budgets Current IT Spend of all Projects", "Current IT Spend of all Projects"})
in
#"Removed Other Columns"
Is the file path wrong? I have an excel sheet uploaded into sharepoint and from sharepoint I open the excel sheet but usually when i inport the data to power bi i have to look for the specific excel sheet.
Expression.Error: 3 arguments were passed to function which expects between 1 and 2.
Details:
Pattern=
Arguments=List
i got this errror
