Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem Appending Queries from NAV Data Source

Hi all,   I'd really appreciate some help on the following issue if possible.   I'm currently pulling 4 different entities data from the NAV data source (OData link) and then trying to append the...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous,

glad to hear that. Please give Kudos for support.