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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
purple_SP
Helper I
Helper I

Refresh single partition in a Dataflow using REST API

Hi everyone, I am currently trying to do an incremental historical load of an entity in a dataflow using the REST API. 

The query in the dataflow uses a NativeQuery. I would like to avoid loading the full history at once, so I am trying the following method (currently testing out with dummy data):

 

- write out the query as a native query and specify "WHERE 1 = 0" in the sql so that no rows are loaded.

-refresh the dataflow with an incremental refresh policy defined, so that partitions are created with no rows

-reopen the dataflow and change the native query to "WHERE 1 = 1"

-save the dataflow, but don't refresh it so that no data is loaded.

-use the REST API to refresh an individual partition and repeat until I have loaded all the partitions necessary

 

In the microsoft interface, I am trying to call the REST API like so:

purple_SP_0-1699595793605.png

However, when I check the refresh history, all of the partitions get populated instead of just the one I specify (Nov 4th in the example above). Just wondering if the issue is with the parameters I am sending to the REST API or if there is a problem with my method?

 

1 REPLY 1
purple_SP
Helper I
Helper I

Just noticed that the Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn seems to be referring to Datasets only. It seems like the only configurable parameter for a dataflow refresh is whether an email notification is delivered on failure or not.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.