Utilizo el siguiente scipt en powerquey in oder para cargar datos, lleva demasiado tiempo, cómo optimizarlos
dejar
Source = Csv.Document(File.Contents("C:\Users\Jawaher\OneDrive\powerbi-export\powerbi-proposals.txt"),[Delimitador=","]),
#"Encabezados promocionados" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Filas filtradas1" = Table.SelectRows(#"Encabezados promocionados", cada uno ([rejected_by_internal_filter] = "false")),
#"Changed Type" = Table.TransformColumnTypes( #"Promoted Headers",{{"id", type text}, {"application_id", type text}, {"bank", type text}, {"amount_approved", Int64.Type}, {"rate", Int64.Type}, {"rate_effective", Int64.Type}, {"monthly_cost", Int64.Type}, {"years_repayment", Int64.Type}, {"consolidation_required", type text}, {"rejected_by_internal_filter", type logical}, {"created_time", type datetime}, {"created_date", type date}}),
#"Consultas combinadas" = Table.NestedJoin(#"Changed Type", {"application_id"}, applications, {"id"}, "applications", JoinKind.Inner),
#"Aplicaciones expandidas" = Table.ExpandTableColumn(#"Consultas combinadas", "aplicaciones", {"cantidad", "amount_approved", "created_date", "accepted_bank", "accepted_amount", "disbursed_date", "disbursed_bank", "disbursed_amount", "utm_clientid", "acceptance_amount", "acceptance_monthly_cost"}, {"applications.amount", "applications.amount_approved", "applications.created_date", "applications.accepted_bank", "applications.accepted_amount", "applications.disbursed_date", " applications.disbursed_bank", "applications.disbursed_amount", "applications.utm_clientid", "applications.acceptance_amount", "applications.acceptance_monthly_cost"}),
#"Filas filtradas1" = Table.SelectRows(#"Aplicaciones expandidas", cada una ([rejected_by_internal_filter] = false)),
#"Filas agrupadas" = Table.Group(#"Filas filtradas1", {"banco", "applications.created_date", "applications.accepted_bank", "application_id", "applications.utm_clientid"}, {{"cantidad", cada List.Max([applications.amount]), tipo número anulable}, {"cantidadaprobada", cada List.Max([applications.amount_approved]), tipo nulo número}, {"amountaccepted", cada List.Max([applications.accepted_amount]), escriba nullable number}, {"disbursed_amount", cada List.Max([applications.disbursed_ cantidad]), escriba número anulable}}),
#"Columnas renombradas" = Table.RenameColumns(#"Grouped Rows",{{"applications.created_date", "created_date"}, {"amountaccepted", "accepted_amount"}}),
#"Grouped Rows1" = Table.Group(#"Renamed Columns", {"bank", "created_date", "applications.accepted_bank", "applications.utm_clientid"}, {{"amount", each List.Sum([amount]), type nullable number}, {"amountapproved", each List.Sum([amountapproved]), type nullable number}, {"accepted_amount", each List.Sum([accepted_amount]), type nullable number}, {"disbursed_amount", each List.Sum([disbursed_amount]), type nullable number}}),
#"Renamed Columns1" = Table.RenameColumns(#"Grouped Rows1",{{"amountapproved", "amount_approved"}, {"applications.accepted_bank", "accepted_bank"}, {"applications.utm_clientid", "utm_clientid"}})
en
#"Columnas renombradas1"
proposals_Sheet
