Incremental API calls using Python script

[Gaurav_Lakhotia]

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

[mahoneypat]

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

[amitchandak]

@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

https://blog.crossjoin.co.uk/2018/10/21/calling-the-power-bi-rest-api-from-microsoft-flow-part-2-ref...