Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
**** 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
Hi @PedroPablo ,
I believe that this thread will walk you through the options to resolve this problem.
DATAMART (PREVIEW) CdsaMashupUserException - Microsoft Power BI Community
Proud to be a Datanaut!
Private message me for consulting or training needs.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |