Option combiner

[Anonymous]

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

[v-venuppu]

Hi @Anonymous,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

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.

[Jai-Rathinavel]

@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.

[lbendlin]

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.

[KarinSzilagyi]

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?