Forum Discussion
Problem Appending Queries from NAV Data Source
Hi mwegener
I tried to use Table.Buffer like you suggested, however the problem still existed.
Upon investigation, all tables were going to a single OData link and therefore the last table each time was replicated by the number of tables. Not really sure why this was happening, but I managed to fix the problem by using a "OData Feed" source instead of the "Dynamics Nav" source.
This allowed me to create a single source for each table which correctly feeds the append.
Thanks so much for your help though! Hope this info is of some use if you come across the issue again!
Aaron
Hey mwegener
Its difficult because of the size of the dataset, and i'd also have to anonymise the data, however this person is facing the exact same problem as me and their screenshots are quite a good way to see it (albeit they are merging 2 tables instead of 4). I believe they are also extracting data from NAV.
Does this help?
Aaron
Hi Anonymous ,
i'm not sure if entry no does not exist in both queries.
But try to isolate the result of the individual query with Table.Buffer and then to append.
https://docs.microsoft.com/en-us/powerquery-m/table-buffer
Hi Anonymous,
glad to hear that. Please give Kudos for support.
Hi mwegener
I tried to use Table.Buffer like you suggested, however the problem still existed.
Upon investigation, all tables were going to a single OData link and therefore the last table each time was replicated by the number of tables. Not really sure why this was happening, but I managed to fix the problem by using a "OData Feed" source instead of the "Dynamics Nav" source.
This allowed me to create a single source for each table which correctly feeds the append.
Thanks so much for your help though! Hope this info is of some use if you come across the issue again!
Aaron