Forum Discussion
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...
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