Forum Discussion
Advanced Power M + Incremental refresh
Dear All, I have written an API call to request data from our team's UiPath Orchestrator server. (using odata, swagger 2.0) Here I would like to use incremental refresh, to request only data between...
Hi Anonymous - have you considered using the Power Query Diagnostic or Fiddler trace to see how many times the Power Query is executing the API call. I just think it might be attempting to call the data multiple times so the 30 minute time out never occurs. You could probably confirm that Power Query is doing something unnecessary from call the API in Visual Studio Code or Postman.
If you find that Power Query is doing something unusual, you may want to consider switching to using Power Automate to call the JSON file. Store the JSON file in SharePoint, or parse it into a Dataverse table.