Forum Discussion
Power BI Server Capacity
Hi aj1973,
This is the code for my advanced editor:
let
Origen = SharePoint.Files("https://****csp.sharepoint.com/00004**4/0**05143/proyectos/***", [ApiVersion = 15]),
#"Maestro Via de Pago csv_https://***csp sharepoint com/00004**4/0**05143/proyectos/***/Documentos compartidos/Documentos/" = Origen{[Name="Maestro Via de Pago.csv",#"Folder Path"="https://***csp.sharepoint.com/00004**4/0**05143/proyectos/***/Documentos compartidos/Documentos/"]}[Content],
#"CSV importado" = Csv.Document(#"Maestro Via de Pago csv_https://****csp sharepoint com/00004**4/0**05143/proyectos/***/Documentos compartidos/Documentos/",[Delimiter="|", Columns=2, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Tipo cambiado" = Table.TransformColumnTypes(#"CSV importado",{{"Column1", type text}, {"Column2", type text}}),
#"Encabezados promovidos" = Table.PromoteHeaders(#"Tipo cambiado", [PromoteAllScalars=true]),
#"Tipo cambiado1" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"Via de pago", type text}, {"Texto pago", type text}})
in
#"Tipo cambiado1"
Thanks in advance.
- aj19732 years agoCommunity Champion
All looks good except maybe here
try to change it to "," please