News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Delete rows in a PBI d...

Power Automate - Building Flows

Unanswered

Delete rows in a PBI dataset using PowerAutomate

(0) Share

Report

Report

Posted on by LpaulaX

8

Hello!

I'm using PowerAutomate to add rows to a dataset everyday, but, I'm getting the same information over and over again everytime the script runs.

I want to delete the actual rows before adding the ones with the new information, is there a way to do it?

Maybe another step before "Add rows to a dataset" will work, but which one?

Thanks

All responses Img

All responses (3)

Answers Img

Answers (0)

lbendlin 7,945 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delete rows in a PBI dataset using PowerAutomate

create a custom connector that includes that API call. The Power BI REST API git page has the Swagger file lying around somewhere.
LpaulaX 8 on at

Like (0)

Report

Re: Delete rows in a PBI dataset using PowerAutomate

@lbendlin
Streaming dataset, premium.
How to use this in powerautomate?
lbendlin 7,945 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delete rows in a PBI dataset using PowerAutomate

It is impossible to delete individual rows in a semantic model. Only (flush and) fill is supported.

Is your semantic model a Push dataset or a Streaming dataset? "My Workspace" or Premium?

Push Datasets - Datasets DeleteRows - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans