Forum Discussion
Power BI incremental refresh policy limitation
Hi Guys, I am struggeling with such problem. I have a power BI report which is configured to pull the data from REST API and has defined incremental refresh policy. API however has a limitation o...
Please read my answer again.
Setting up last 3 years causes that API is being requested in 1 year chunks in the initial dataset build, which causes API faults. To prove it I could send yt video.
As I wrote in the first post, API is limited (!) to 10k records and 30secs timeout, so the question is: is it possile to achive some kind of solution with that setup which I got?
The conclusion is that API is serving small portion of data and the desired resolution would be how to catch those small chunks in dataset and build on that data analysis.
Regards,
Artur