Forum Discussion
Pablo26
Mar 06, 2023Copper Contributor
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?
- Pablo26Copper ContributorAditional 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