Forum Discussion
Community ChampionEnhanced API Incremental Refresh
Figured out what's wrong. Submitted more than necessary in the body of the API request. Stuff in green is unnecessary.
Most Valuable ProfessionalHi littlemojopuppy ,
Have you defined incremental refresh policies for both tables? It might be if just one of them has one, that Power BI falls back to standard behviour and does a full refresh of the whole dataset. Also, if I recall correctly, if a table does not exist in the model specified in the body then a full refresh is triggered as well (I am not 100% sure though whether that statement is true though)
Please note, I am not an expert when it comes to incremental refreshes. So I am keen to be part of this learning experience 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Community ChampionHi tackytechtom
Thanks for replying. Yes, incremental policy is defined on both tables.
What's weird, and I probably should have mentioned this in the original post is that I can run that second script in SSMS and (with one modification: adding in the database with the table) it runs exactly as expected. Which is why I feel like I'm banging my head against the wall.
- littlemojopuppy
Figured out what's wrong. Submitted more than necessary in the body of the API request. Stuff in green is unnecessary.