Forum Discussion

MiguelRosales's avatar
MiguelRosales
Regular Visitor
9 years ago

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 in...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

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's avatar
MiguelRosales
Regular Visitor
9 years ago

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's avatar
    MiguelRosales
    Regular Visitor
    9 years ago

    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

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      9 years ago

      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.

       

      • mthsdiniz's avatar
        mthsdiniz
        Frequent Visitor
        7 years ago

        Eric_Zhang is there anyway to execute this DELETE request from powershell?