I successfully transformed an excel file with no errors. After save & load, the file loads fine into excel. When I add a new file, and press refresh and it will not refresh. The data files are kept in a separate folder. I have tried "transform & load" and "transform" but neither method will refresh. I am not getting any error messages while transforming the data. I must be missing something over and over because I have started from scratch 5 times and always get the same result, NO REFRESH.
Are you replacing the original file, or adding a new file to a folder? If the latter, did you use the From Folder option when creating the query?
It would probably help to post the M code (from View tab - Advanced editor in the PQ editor) here for us to review.
