Forum Discussion
Gaurav_Lakhotia
Helper III
Helper IIIIncremental API calls using Python script
Hello,
I am looking for a solution to a problem while refreshing the data which I have imported using Python connector.
I am calling the data from REST API using a python code and used this code directly in Power BI. Now, every time if we refresh the data we are calling all the rows, which is hitting the API limit.
I want to check if DWH is the only option or if it can be brought incrementally in Power BI.
Any ideas?
Thanks in advance
2 Replies
- amitchandak
Super User
Gaurav_Lakhotia , based on what I got from the description, of the two might help you
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
or
- mahoneypat
Microsoft Employee
Here is another video you can check out with a good approach for making multiple API calls with power query.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
