Not show all files from Sharepoint folder - Power BI and Power Query

carlosam14

New member
Joined
Jun 11, 2017
Messages
6
Reaction score
0
Points
0
Location
Mexico
Excel Version(s)
365
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"}),
Not files.jpg
 
Back
Top