Enhanced API Incremental Refresh

[littlemojopuppy]

Hello!

Would like to ask for some help with something.  I have a dataset configured for incremental refresh I'm trying to refresh using the API.  Been banging my head against a wall for a couple days on this so I would really appreciate any help anyone could offer.

This script works exactly as intended...completes only the most recent day, finishes in under two minutes

{
	"refresh": {
	"type": "automatic",
        "commitMode": "transactional",
	"objects": [
		{
			"table": "Sales Invoice Transactions"
		}
	],
        "applyRefreshPolicy": "true"
	}
}

This script does not...it seems to ignore listing multiple tables and attempts to refresh the whole dataset,  Runs for an hour before it gets throttled for resources.

{
	"refresh": {
	"type": "automatic",
        "commitMode": "transactional",
	"objects": [
		{
			"table": "Sales Invoice Transactions"
		},
		{
			"table": "Sales Order Transactions"
		}
	],
        "applyRefreshPolicy": "true"
	}
}

Can anyone provide some ideas on what's wrong with the second script?  Much appreciated!

[tackytechtom]

Hi @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/

[littlemojopuppy]

Hi @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 · Accepted solution]

Figured out what's wrong.  Submitted more than necessary in the body of the API request.  Stuff in green is unnecessary.