I have separate service data with a single workbook for each product. Structure (columns) is identical for each workbook.
I built a query to initially bring together four separate workbooks in the same folder and this has worked really well. Very happy at how easy PowerQuery is and how much time can be saved.
However, I now want to add more workbooks to the same folder and have the query bring in all workbooks.
Unfortunately it only seems to update/refresh the four initial workbooks.
Thoughts ?
Many thanks in advance
Neil
Nope! I'd need to see the M code to get at least an idea. Please also provide list of workbook names, including file extensions.
Thanks,
Mynda
Thanks Mynda,
Had not occurred to me to look at the M-code. Having done so, there is a filter which in effect re-selects only the four initial workbooks.
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each ([Hidden] = false) and ([Kind] = "Table") and ([Item] = "QuattroIIService" or [Item] = "QuattroMicroService" or [Item] = "QuattroPremXEParts" or [Item] = "XEVOTQParts")),
I believe that if I 'expand' the filter, then I should be able to get any additional workbooks included. Alternatively, I could have been little smarter building the query.
Will experiment as this is in development, but thanks for the guidance and pointer !
Neil
Perfect, Neil. It's great to see you have the confidence to experiment with different things to find a solution.
I'm always here if you get stuck, but I'm pleased to see you're trying things out yourself, as you will learn more this way than if I just give you the solution.
Mynda
