Forum Discussion
Adding and removing files from my data source
Hello, I am very new to power query, but created a sheet that was working, but for some reason stopped. I try to refresh the data but it takes a painfully long time. I get an expression error but...
What connector are you using? File, Folder, or Sharepoint Folder? Can you show a sanitized version of the Power Query code?
You mention Sheets. Are you iterating trhough all sheets on all Excel files in a folder?
- It's a folder on my desktop, it's going through all the xls files in that folder. I can't unfortunately show that. My job computer is pretty restrictive.
I would recommend you move that folder to a OneDrive. I hope xls was a typo. Don't ever use xls or xlsb. Only use xlsx or xlsm.
It was! Apologies, I didn't have that option, I wish I could explain better. I can't even get the preview up when editing the query. Even when I'm testing it with a single file in the source folder.
