cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhanudaybirla Frequent Visitor
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

5 REPLIES 5
Community Support Team
Community Support Team

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

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 Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
bhanudaybirla Frequent Visitor
Frequent Visitor

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

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

Community Support Team
Community Support Team

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

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 Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
gv73 Occasional Visitor
Occasional Visitor

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

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

 

Naol_Koo Visitor
Visitor

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

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,

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 429 members 4,288 guests
Please welcome our newest community members: