cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiguelRosales Frequent Visitor
Frequent Visitor

Restful powerBI delete streaming

Hello, I'm fairly new to power BI, I'm currently working with the streaming  restful API. I created the restful endpoint following a tutorial online and the POST operation works. I am able to push information and read it. I now need to delete the data from the table. My restful address when I push information looks like this

https://api.powerbi.com/beta/[STRING1]/datasets/[STRING2]/rows?key=[PRIVATE KEY]

It was provided to me by power BI when I created the endpoint.

I'm guessing STRING1 corresponds to some sort of userID and STRING2 to my dataset

I found this DOC to delete the rows

https://msdn.microsoft.com/en-us/library/mt238041.aspx

The address doesn't match my endpoint address (I don't know what the table name is furthermore BETA and V1.0 are different I'm assuming)

DELETE https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

I have tried a

DELETE https://api.powerbi.com/beta/[STRING1]/datasets/[STRING2]/rows?key=[PRIVATE KEY] and I got a 404 ERROR

 

Any I deas?

 

Thank you.

4 REPLIES 4
Moderator Eric_Zhang
Moderator

Re: Restful powerBI delete streaming

@MiguelRosales

 

The DELETE ROWS api is for the regular datasets, suchs ones published from desktop, get data from service and even the "HISTORIC" data for steaming dataset.

 

AFAIK, there's no api to delete rows in a streaming dataset, you'll have to delete and re-create a new one. You can submit this at Power BI Ideas and vote it up.

MiguelRosales Frequent Visitor
Frequent Visitor

Re: Restful powerBI delete streaming

thank you,

what would a http request for a DELETE preformed on a "historic" data of a streaming dataset.

 

That is what I was refering to actually. I need to clear the historic data. 

 

MiguelRosales Frequent Visitor
Frequent Visitor

Re: Restful powerBI delete streaming

I just found out that the name of the table is RealTimeData (default name)

 

When I try to delete it I get a 403, do I have to authenticate to be able to delete the data?

 

If yes, can someone provide information about about the authentication procedure in order to perform such action?

 

thanks

Moderator Eric_Zhang
Moderator

Re: Restful powerBI delete streaming

@MiguelRosales

The DELETE API can delete the historic dataset according to my test. You'll have to specifiy an field "Authorization" valuing the "Bearer token" in the HTTP request header.

 

See a quick way to get the token in this thread.

 

Capture.PNG