Bonjour le fil
Semble fonctionner en ouvrant en UTF-8 et modifiant les types avec paramètres régionnaux "en-US" :
let
Source = Csv.Document(File.Contents("Z:\Fichier 20200713.csv"),[Delimiter=";", Columns=45, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"En-têtes promus" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Type modifié" = Table.TransformColumnTypes(#"En-têtes promus",{{"#DAT_APPEL", type date}, {"CONNID", type text}, {"TYP_APPEL", type text}, {"ORDRE_TRANSFERT", type text}, {"NIV_DELESTAGE", type text}, {"NUM_TIRAGE", type text}, {"HEU_ATTENTE", type text}, {"LIB_TYP_CONTACT", type text}, {"LIB_MEDIA_SVI", type text}, {"ANI", type text}, {"NUM_CLIENT", type text}, {"NUM_DISTRIBUTEUR", type text}, {"DNIS", type text}, {"APPLICATION_SVI", type text}, {"MOTIF", type text}, {"POPULATION", type text}, {"PEG_STAT_1", type text}, {"PEG_STAT_2", type text}, {"PEG_STAT_3", type text}, {"STRATEGIE", type text}, {"ID_STT_DISTRIBUTION", type text}, {"ID_AGENT", type text}, {"LOGIN_TEL", type text}, {"LIB_GRP_AGENT", type text}, {"NOM_AGENT", type text}, {"PRENOM_AGENT", type text}, {"DUR_SONNERIE", type text}, {"DUR_CONVERSATION", type text}, {"DUR_GARDE", type text}, {"DUR_CONSULTATION", type text}, {"DUR_TAA", type text}, {"CAUSE_DISSUASION", type text}, {"COD_CONTEXTE_DISTRIBUTION", type text}, {"COMPETENCE_TRT", type text}, {"SITE", type text}, {"MOTIF_TRF", type text}, {"SITE_ORIGINE", type text}, {"ID_MOD_ROUTAGE", type text}, {"LIB_THEME", type text}, {"LIB_RUBRIQUE", type text}, {"LIB_SOUS_RUBRIQUE", type text}, {"FLG_RONA", type text}, {"DUR_ATTENTE", type text}, {"DUR_ATTENTE_ESTIMEE", type text}, {"SRC_REFUS_ENRG", type text}},"en-US")
in
#"Type modifié"
bonne journée