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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.