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

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

Reply
flennon
Frequent Visitor

Delete rows from dataset with REST API

I can't seem to find any documentation on how to delete data from a push dataset using a Delete request with the API. Is that functionality available?

 

As there is no rolling hour filtering capabilities on reports/visuals, I want to delete any rows in the dataset older than X number of hours using the API. This way I dont have to filter the report but it would always display the last X number of hours.

 

Any Advice would be greatly appreciated.

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @flennon,

 

There is a REST API called datasets_deleterowsingroup. But it will delete all the rows. Maybe you can give it a try.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @flennon,

 

There is a REST API called datasets_deleterowsingroup. But it will delete all the rows. Maybe you can give it a try.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Where do I get the missing variable values?

E.g.  "myorg", data set id?

Do I need an API key or some other auth token?

 

The doc says to use this URL for DELETE

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.