Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
231
Views
Topic starter
Hello - so I have been using an Excel table with Queries and Connections to connect to external data (API of cryptocoins).
Everything worked fine UNTIL I added the API of more than 50 coins in the source line. When I load the table back into Excel, only 50 lines appear - the others are not showing. I double-checked and the source is correct.. so I suspect there is a some kind of a limit somewhere... but not sure where to look!
Thanks for your advice
LadyC
Posted : 08/09/2021 9:36 am
Hi Cecile,
Welcome to our forum! This will be a limitation of the API. Often companies limit API calls to reduce load on their servers. You would need to address this with them.
Mynda
Posted : 08/09/2021 8:50 pm