carlosam14
New member
Hi! My Friends I do not know how to happen ... I use same query on Power BI and Power Query, my problem is, since this last wednesday did not show all files storage on my sharepoint folder
PowerBI and PowerQuery has same result on files extract from Sharepoint
this my query
let
Source = SharePoint.Files("https://xxxxxxx.sharepoint.com/opstto/", [ApiVersion = 15]),
#"Reordered Columns1" = Table.ReorderColumns(Source,{"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Folder Path", "Attributes"}),
#"Filtered Rows1" = Table.SelectRows(#"Reordered Columns1", each ([Folder Path] = "https://xxxxxxx.sharepoint.com/opstto/Documentos compartidos/Costo Operativo/Archivos fuente/Requisiciones/")),
#"Sorted Rows1" = Table.Sort(#"Filtered Rows1",{{"Date modified", Order.Descending}}),
#"Filtered Rows" = Table.SelectRows(#"Sorted Rows1", each Text.StartsWith([Name], "Reporte")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content"}),

PowerBI and PowerQuery has same result on files extract from Sharepoint
this my query
let
Source = SharePoint.Files("https://xxxxxxx.sharepoint.com/opstto/", [ApiVersion = 15]),
#"Reordered Columns1" = Table.ReorderColumns(Source,{"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Folder Path", "Attributes"}),
#"Filtered Rows1" = Table.SelectRows(#"Reordered Columns1", each ([Folder Path] = "https://xxxxxxx.sharepoint.com/opstto/Documentos compartidos/Costo Operativo/Archivos fuente/Requisiciones/")),
#"Sorted Rows1" = Table.Sort(#"Filtered Rows1",{{"Date modified", Order.Descending}}),
#"Filtered Rows" = Table.SelectRows(#"Sorted Rows1", each Text.StartsWith([Name], "Reporte")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content"}),
