Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Community Champion
3 years ago
Solved

Enhanced API Incremental Refresh

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!

  • littlemojopuppy's avatar
    littlemojopuppy
    3 years ago

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

     

3 Replies

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional

    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's avatar
      littlemojopuppy
      Community Champion

      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's avatar
        littlemojopuppy
        Community Champion

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