Forum

Hi Sebastien, I'm not clear on whether you are now trying to merge files where some have 8 columns and some have 9? Looking at your queries it l...

Hi Jen, Without access to your query and the source data it's very difficult to give you an answer. The query may be not loading for many reasons....

No worries.

Hi Steven, You can load the query results to any sheet you like. When you click on Close & Load To you can choose to load to an Existing works...

Hi Declan, Can you supply your file? #REF is generated in the Excel sheet, not in PQ or the data Model, so somewhere in a sheet that error is oc...

Hi Jen, I can't find a published limit for the number of steps. But if there was on, I'd imagine it would be in the 100's or 1000's. It'd be be...

Hi Lee, To achieve this you call the RT function again and pass in the Value and Region columns. Just make sure you sort the table by Country firs...

Hi Leonardo, You can add a key to a table using the Table.AddKey() like so Keyed_test_map = Table.AddKey(test_map, {"Function"} , true) Wheth...

Hi Bax, How exactly is the query failing? If you are loading files from a Sharepoint folder and the structure of a file is totally different then ...

Hi David, Please supply a workbook like the one attached, not a table of data that still has to be copied/pasted to create a workbook Regards ...

Hi Wayne, I think what you are after is a Grouped Running Total, I wrote about this here Grouped Running Totals in Power Query • My Online Train...

Hi Andrzej, You can do this by creating a list of the ID numbers ID_List = {1..686} Any number over 686 caused a 404 Not Found error on the ...