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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bhanudaybirla
Frequent Visitor

How can we delete rows in power bi push dataset using rest api?

I have to show real time data on my dashboard. And for that, i am using power bi rest api to push data into it in historical data analysis mode. I am able to push data using a rest api push url provided while creating streaming data. But i need to delete all the data before pushing each single row. I am doing this because i want to use all visualizations which are available for historical data analysis mode only. But i dont need historical data, so i want to delete all data before pushing new row. But Its showing 401 Unauthorized error while doing deletion using python's requests library. Do we have to mention group id , dataset id and table name seperatly or the push url generated will work? I am getting push URL from below screen.Untitled.png

7 REPLIES 7
ivanstankov
Frequent Visitor

This issue is still relevant! In regular push dataset you can do that now, but in simplified streaming api you can't. Such a silly thing. In fact, you can only drop historical data manually and then re-push all data again...

sqlitybi
Regular Visitor

I have recently made a post on how to delete data from a push dataset using PowerShell. Maybe you can see if your script is the same to resolve your 401 error.

 

https://sqlitybi.com/how-to-delete-data-from-push-streaming-dataset-power-bi/

Anonymous
Not applicable

Any idea on how to accomplish this? PushStreaming (hybrid) dataset that needs to be reset every few seconds. 

So here is the goal:

 

Delete all the rows at the rest api endpoint-->Push the new data (say from sql view) ---> the report/visual refrshes. I am working on a requirement where this has to happen every few seconds.

Why am I not doing the Streaming dataset? Because I need to use a custom visual (not to be limited by the few visuals available to the streaming option). 

Thank you,

gv73
New Member

Hi,

Is there an update to this? Is this roadmaped? Being able to delete certain rows from a streaming data set with history enabled has been on my xmas wish list for a while. Or, to be able to empty a dataset through the web UI.

Simple no-auth post calls into streaming datasets is super useful, versatile and easy. Yet, from my personal experience, it does feel extra silly to delete and re-create an entire dataset, simply to correct mistakes or undo accidental duplicate posts. I've done it a bunch of times...

Cheers, Gregor

 

v-shex-msft
Community Support
Community Support

HI @bhanudaybirla,

 

>>But i need to delete all the data before pushing each single row

Current streaming dataset has no underlying data, it used receive data pushed data without other operations.

 

As with the streaming dataset, with the PubNub streaming dataset there is no underlying database in Power BI, so you cannot build report visuals against the data that flows in, and cannot take advantage of report functionality such as filtering, custom visuals, and so on.

 

In my opinion, if you not need historical data, you can simply turn off it.

2.PNG

 

When Historic data analysis is disabled (it is disabled by default), you create a streaming dataset as described earlier in this article. When Historic data analysis is enabled, the dataset created becomes both a streaming dataset and a push dataset. This is equivalent to using the Power BI REST APIs to create a dataset with its defaultMode set to pushStreaming, as described earlier in this article.

 

Real-time streaming in Power BI

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

But if i disable historical data analysis, i can not use all power bi visuals.

Hi @bhanudaybirla,

 

 

As I said, streaming api not support any operation except push data.  So I think your requirement is impossible to achieved at present.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors