Forum Discussion
PowerBi call API specific ID number from column
Hi all,
In PowerBi I can call an API history from data with a specific record ID. My API ends with ......export/"ID number"
In this case my export give's me all the data. If I don't use the ID number at the end, I get less columns.
There are more then 200.000 records with an unique ID number in column A.
I want all the records in one table. Is it possible to make an automatic call for each ID number starting with 1 and so on untill there are no more ID numbers? So only show records with matching ID values?
Certainly possible. But it will take an extraordinary amount of time to do this with individual calls, and you will very soon hit a 429 ("Too many requests") so you have to space this out.
The data is immutable, so you should store the results of each call as a JSON, and never make that call again.
What is the business problem you are trying to solve?
3 Replies
Certainly possible. But it will take an extraordinary amount of time to do this with individual calls, and you will very soon hit a 429 ("Too many requests") so you have to space this out.
The data is immutable, so you should store the results of each call as a JSON, and never make that call again.
What is the business problem you are trying to solve?
Hi Tinus1905 ,
May I ask if your problem has been resolved? If lbendlin 's response was helpful, you may consider marking it as resolved. If the problem is not yet solved, please feel free to ask us questions.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
