Forum Discussion
PedroPablo
3 years agoHelper I
cant upload sharepoint csv file to datamart - https: 400 and status code 500
its posible could you help me to upload file I attach the steps: Activity ID: 7091d74e-1a11-c8ea-7a4e-f65da64b6b62 Request ID: efc7fe33-e99...
PedroPablo
3 years agoHelper I
**** update Information ***** 10-05-2023
When I try to load file with this:
let
Source = Csv.Document(Web.Contents("https://xxx.sharepoint.com/personal/xxx/Documents/Apps/Microsoft%20Power%20Query/Uploaded%20Files/yyyy.csv"), [Delimiter = ";", Columns = 49, Encoding = 65001, QuoteStyle = QuoteStyle.None]),
#"Promoted headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
#"Removed other columns" = Table.SelectColumns(#"Promoted headers", {"Fecha de documento"})
in
#"Removed other columns"
it's works
but when conector is:
let
Source = SharePoint.Files("https://xxxxx.sharepoint.com/sites/xxx/", [ApiVersion = 15]),
#"Filtered rows" = Table.SelectRows(Source, each Text.Contains([Folder Path], "/path_file")),
#"Sorted rows" = Table.Sort(#"Filtered rows", {{"Folder Path", Order.Ascending}}),
#"Lowercased text" = Table.TransformColumns(#"Sorted rows", {{"Extension", each Text.Lower(_), type text}}),
#"Filtered rows 1" = Table.SelectRows(#"Lowercased text", each ([Extension] = ".csv") and ([Folder Path] = "https://xxxxx.sharepoint.com/sites/xxxxx/Documentos compartidos/path_file/zzzzz/"))
in
#"Filtered rows 1"
dont work
Can someone help and check why the load with sharepoint is not working