Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
littlemojopuppy
Community Champion
Community Champion

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!

1 ACCEPTED SOLUTION

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

littlemojopuppy_0-1675460421855.png

 

View solution in original post

3 REPLIES 3
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

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.

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

littlemojopuppy_0-1675460421855.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.