Forum Discussion

PedroPablo's avatar
PedroPablo
Helper I
3 years ago

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-e99d-4bcd-8e42-560ab97957ee
Status code: 500
Error Code: CdsaMashupUserException
Batch ID: 2d583e7b-d1f7-49bc-b551-3fcb8323162c@59c73a14-9516-4e97-b3bd-a1a7cb7e1438$2023-05-09T15:18:25.2734344Z@8196b1d6-d620-407b-9e7a-8e87a0bd20f8

 

When I try to save again, show me

 

 

 

General Comment
Need Help

3 Replies

    • PedroPablo's avatar
      PedroPablo
      Helper I
      3 years ago

      Thanks collinq , but it doesn't seem to work. I made the file smaller (2 columns and one row) and the error that appears is:

       

       

       

       

       

       

       

  • PedroPablo's avatar
    PedroPablo
    Helper I
    3 years ago

    **** 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