Forum Discussion
Automatically Gather Extra Data
Anonymous yes, you don't need to manually add new documents in PQ, you just need to reach the folder and process all the files. Check this awesome post.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
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!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserAnonymous yes, you don't need to manually add new documents in PQ, you just need to reach the folder and process all the files. Check this awesome post.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
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!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks for your help and really quick reply 😊.
So, I connect to the folder and can list of documents within the folder. How do I go about performing the same transformation steps on every document? I can see the combine option, but the files need a lot of transformation before they're combined.
Sorry if that's an obvious question.
Ignore the above. I got it all sorted, thanks. I spent 2 days trying to working out why it wasn't working and it turns out that the data I was pulling through was dated incorrectly so at first (and second, third, fourth etc) glance, it looked like the same data being pulled through multiple times when, in actuality, it was the correct data just with the wrong date on it.
And, apologies for the delay in replying.