Forum Discussion
How combine multiple files from folder NO table
and after it should be like this :
Do not forget that the most left is 0, then 1. So you might have to change the number if your data are not on the most left sheet of your files.
You might have to add a step to promote headers but not always the case. Just check if your headers are in place otherwise add a step after Navigate to promote headers.
Tell us if it works...
Frixel I know what the fix is but hard to explain, can you send pbix file with two sample files one with table and one without table and I will put together the solution.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!