Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SharePoint Folder - not combining files

Hi everyone, I'm having an issue where I'm trying combine some files through using the SharePoint Folder as the source. In Power BI Power Query, I can locate the files and filter down to the fo...
Need Help
Adib_k's avatar
Adib_k
New Member
2 years ago

If you’re encountering issues with File Combining, it could be related to the file type or the file name. Here’s a step-by-step solution that has worked for me in similar situation:

  1. Convert all files to the same format: Ensure that all files are in a uniform format/type before attempting to combine them.
  2. Rename your files: Check for any special characters in the file names, such as “#!?”. These can sometimes cause issues.
  3. Refresh your dataset: After renaming the files, go to “Query Refresh Preview” and select “Refresh All”.
  4. Combine the files: Once the dataset is refreshed, you should be able to combine the files successfully.

Hopefully following these steps should resolve the problem.