Forum Discussion
Option combiner
Bonjour,
L'option "combiner les fichiers" est grisée et je ne peux pas la selectionnée, pouvez vous m'aider à résoudre le problème svp
5 Replies
- KarinSzilagyiSuper User
Hi Anonymous, "Combine Files" is only available for specific source-types (as far as I'm aware Excel, CSV, TXT, JSON, XML in Folder, SharePoint Folder, Azure Blob Storage, Azure Data Lake Storage): https://learn.microsoft.com/fr-fr/power-query/combine-files-overview
What are the source-type of the files you want to combine?
Also, to use "Combine Files", you first need to select a column that contains the file binaries (usually called "Content" with "Binary" values in each row). Is it still grayed out for you if you select your "Content"-column? - lbendlinSuper User
Additionally, "Combine Binaries" creates a lot ( A LOT) of gruft that you don't really need nor want. Better to do that file contents append yourself. I have a blog entry on that somewhere if you are interested.
- Jai-RathinavelSuper User
Anonymous
Pouvez-vous confirmer que tous les fichiers présents dans votre dossier ont la même extension (par exemple tous en .xlsx ou tous en .csv) ?
Si le dossier contient différents types de fichiers, Power Query peut désactiver l’option “Combiner les fichiers”.Note : Ce message a été traduit à l’aide de l’IA.
- v-venuppuCommunity Support
Hi Anonymous ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Jai-Rathinavel lbendlin KarinSzilagyi for the prompt response.
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?If not resolved, can you please provide the details requested, so that it will be helpful for us to solve the issue.
Thank you.