"Erreur OLE DB ou ODBC: [DataSource.Error] Nous avons obtenu l'erreur d'E/S '64' "

[GeekAlfPro]

Hello,

i created a function for folder with Power Query.

it works fine, when i click on the last step, my data seem to display well.

the issue is when i click on Close an Load, i have this message 

Échec de l'enregistrement des modifications sur le serveur. Erreur retournée : « Erreur OLE DB ou ODBC: [DataSource.Error] Nous avons obtenu l'erreur d'E/S '64' alors que nous tentions d'accéder au chemin 'Y:\TOTO\Fichiers\INCIDENT\*'..

it seems that is due to the subfolder in my function.

i tried to add a table.removerows with errons but without success

here is my code

let
    Source = Folder.Files("Y:\TOTO\Fichiers\INCIDENT"),
    #"Lignes filtrées" = Table.SelectRows(Source, each Text.StartsWith([Name], "interface_Pic") and [Name] <> "interface_Pic_sav_25082021.csv"),
    #"Colonne fusionnée insérée" = Table.AddColumn(#"Lignes filtrées", "CheminComplet", each Text.Combine({[Folder Path], [Name]}, ""), type text),
    #"Fonction personnalisée appelée" = Table.AddColumn(#"Colonne fusionnée insérée", "fcInterfaceVixcol", each fct_Incident_Vix([CheminComplet])),
    #"Erreurs supprimées1" = Table.RemoveRowsWithErrors(#"Fonction personnalisée appelée"),
    #"fcInterfaceVixcol développé" = Table.ExpandTableColumn(#"Erreurs supprimées1", "fcInterfaceVixcol", {"Date", "Heure", "Statut", "Action", "NumAbo", "ProdBill", "NumCarte", "Commentaire"}, {"Date", "Heure", "Statut", "Action", "NumAbo", "ProdBill", "NumCarte", "Commentaire"}),
    #"Colonnes supprimées" = Table.RemoveColumns(#"fcInterfaceVixcol développé",{"Content", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path", "CheminComplet"})
in
    #"Colonnes supprimées"

i mention that i have access to the subfolder in my explorer.

thanks for your help

[GeekAlfPro · Accepted solution]

Hello,

after a few moment today, i don't get the error message anymore.

maybe a network issue (i'm behind a vpn)

thanks for your time

[v-easonf-msft]

Hi, @GeekAlfPro 

It's pleasant that your problem has been solved. You can accept your reply as solution to close this thread.

It may help other community members easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[lbendlin]

Please describe what 

fct_Incident_Vix

does.

[GeekAlfPro]

Hello @lbendlin 

My fonction does the following steps

let
    Source = Csv.Document(File.Contents(Param_Folder_Incident),[Delimiter=";", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Colonnes renommées" = Table.RenameColumns(Source,{{"Column1", "Date"}, {"Column2", "Heure"}, {"Column3", "Statut"}, {"Column4", "Type Modification"}, {"Column5", "NumAbonne"}, {"Column6", "Produit Billettique"}, {"Column10", "Commentaire"}, {"Column7", "prodbill2"}, {"Column8", "NumCarte"}, {"Column9", "NonUtilise"}}),
    #"Colonne conditionnelle ajoutée" = Table.AddColumn(#"Colonnes renommées", "NumAbonné", each if [Type Modification] is number  then [Type Modification] else ""),
    #"Personnalisée ajoutée" = Table.AddColumn(#"Colonne conditionnelle ajoutée", "Action", each if not([Type Modification] is number)  then [Type Modification] else ""),
    #"Personnalisée ajoutée1" = Table.AddColumn(#"Personnalisée ajoutée", "NumAbo", each if not([Type Modification] is number)  then [NumAbonne] else [NumAbonné]),
    #"AjoutProdBill" = Table.AddColumn(#"Personnalisée ajoutée1", "ProdBill", each if not([Type Modification] is number)  then [Produit Billettique] else [Column7]),
    #"Type modifié2" = Table.TransformColumnTypes(AjoutProdBill,{{"ProdBill", type text}}),
    #"Colonnes supprimées" = Table.RemoveColumns(#"Type modifié2",{"NonUtilise"}),
    #"Colonnes supprimées1" = Table.RemoveColumns(#"Colonnes supprimées",{"Type Modification", "NumAbonne", "Produit Billettique", "prodbill2"}),
    #"Colonnes permutées" = Table.ReorderColumns(#"Colonnes supprimées1",{"Date", "Heure", "Statut", "NumAbonné", "Action", "NumAbo", "ProdBill", "NumCarte", "Commentaire"}),
    #"Colonnes supprimées2" = Table.RemoveColumns(#"Colonnes permutées",{"NumAbonné"})
in
    #"Colonnes supprimées2"