Forum Discussion

mvcsharepointde's avatar
mvcsharepointde
Icon for Helper II rankHelper II
2 years ago

Getting duplicate items from external API after i applied paging

I have this formula inside my Power BI desktop to get data from external API using Pagination:-   let PageSize = 10000, // The number of rows you want to retrieve per page GetData = (O...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

mvcsharepointde 

 

Can't see anything obviously wrong in the code.

 

If you make a single call to the API do you get the records returned twice?

 

Whilst you work on finding the cause of this, you can remove duplicates from the ID column to get a single row of data per ID.

 

Regards

 

Phil