Forum Discussion

Pablo26's avatar
Pablo26
Copper Contributor
Mar 06, 2023

DataSource.Error Cant not finde part of the route

Good morning!

I have cretaed one excel file that get data from another excel file using "Get data" "from Excel Workbook" 

Both files are in the same route in a shared Google Drive folder

 

Some persons that have acces to the saher Drive can open the file with out any problem, but others when oppening the file have a message of  "DataSource.Error: can not finde part of the route"

 

I get the route information in two cases and seems to be the same 

 

Route person with no trouble: 

let
Origen = Excel.Workbook(File.Contents("G:\Unidades compartidas\Logística\Seguimiento Logístico - Test\Consolidado Seguimiento de Órdenes de Pedido.xlsx"), null, true),
#"2022_Sheet" = Origen{[Item="2022",Kind="Sheet"]}[Data],
#"Encabezados promovidos" = Table.PromoteHeaders(#"2022_Sheet", [PromoteAllScalars=true]),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"Orden de Pedido", type text}, {"Ítem", type any}, {"Lote", type text}, {"OrdenÍtemLote", type text}, {"Fecha", type date}, {"Proveedor", type text}, {"Molino", type text}, {"Cliente", type text}, {"# OC", type any}, {"Material", type text}, {"Unidad", type text}, {"Cantidad", type any}, {"Incoterm", type any}, {"Precio/unidad", Int64.Type}, {"Total orden", type any}, {"Partner", type text}, {"Condición de pago", type text}}),
#"Filas filtradas" = Table.SelectRows(#"Tipo cambiado", each ([Proveedor] = "Heinzel" or [Proveedor] = "Heinzel AP" or [Proveedor] = "Heinzel PUSA" or [Proveedor] = "Heinzel WHAG"))
in
#"Filas filtradas"

 

Route person with truble: 

let
Origen = Excel.Workbook(File.Contents("G:\Unidades compartidas\Logística\Seguimiento Logístico - Test\Consolidado Seguimiento de Órdenes de Pedido.xlsx"), null, true),
#"2022_Sheet" = Origen{[Item="2022",Kind="Sheet"]}[Data],
#"Encabezados promovidos" = Table.PromoteHeaders(#"2022_Sheet", [PromoteAllScalars=true]),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"Orden de Pedido", type text}, {"Ítem", type any}, {"Lote", type text}, {"OrdenÍtemLote", type text}, {"Fecha", type date}, {"Proveedor", type text}, {"Molino", type text}, {"Cliente", type text}, {"# OC", type any}, {"Material", type text}, {"Unidad", type text}, {"Cantidad", type any}, {"Incoterm", type any}, {"Precio/unidad", Int64.Type}, {"Total orden", type any}, {"Partner", type text}, {"Condición de pago", type text}}),
#"Filas filtradas" = Table.SelectRows(#"Tipo cambiado", each ([Proveedor] = "Heinzel" or [Proveedor] = "Heinzel AP" or [Proveedor] = "Heinzel PUSA" or [Proveedor] = "Heinzel WHAG"))
in
#"Filas filtradas"

 

Can I get some help?

  • Pablo26's avatar
    Pablo26
    Copper Contributor
    Aditional information
    Me and the person with no trouble we are both in Uruguay
    The two persons with trouble they are both in Argentina

    I have Excel Version 2302
    The other person in Uruguay with no truble have Excel Version 2301
    On of the persosn in Argentina with trouble have Excel Version 2301

Resources