Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI Incremental Refresh fails with Too Many Requests

Hi,   I'm trying to use the Incremental Refresh functionality in PBI Dataflows by connecting to 3 different tables via ODATA feed. All these tables are part of the same dataflow. If I refresh the ...
Need Help
Tips and Tricks
jeffshieldsdev's avatar
jeffshieldsdev
Icon for Solution Sage rankSolution Sage
5 years ago

In my example here, initial refresh will query last 5 full years (so starting 2015-01-01), each refresh afterwards will clear out the previous 3 days and make three calls to refresh for each day.

DateTime column should be the create date for a record--don't use modified date.  Incremental refresh is for appending new records, the only records updated will be those in the "refresh rows" range (since that data is cleared out and requeried).

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I'm using Creation Date, I know that if I use Update Date I will start having duplicates.

This is the current configuration, the initital refresh is the one that fails. If I don't use incremental refresh, the initial refresh completes in about 18 minutes.