Doubt about how to send POST Rows via POST to DataSet in PowerBI DataSet

[robertoitu]

Helo,

I am a free user, thinking about becoming a Pro user, I'm having some problems on how to send Post Rows to PowerBi REST API, I have a RealTimeData created in my account and I've tried to send POST rows through POSTMAN and I succeed, I collected the code in POSTMAN (it gives us how to send data in the code of our choice) in PHP and have sent to POWERBI REST API, but it doesn't work, but when I go back to POSTMAN it works ! Do I have to send a Token together ? Why does it work through POSTMAN if it also doesn't have a token too ? How can I get a token ? Is it possible for a free user ? Dou you have an example on how to send it through PHP ?

[amitchandak]

@robertoitu , refer if these can help

https://radacad.com/power-bi-custom-connector-connect-to-any-data-sources-hello-world

https://carldesouza.com/how-to-call-the-power-bi-rest-api-from-postman/

[robertoitu]

Hi @amitchandak !

Unfortunately it didn't work, I did just as the link you've sent instructed and got a register app in the Azure with its Id and Password, but when I used in Postman to send POST to get my Token, the answer is as described below: (I still have the doubt if it's necessary to have a Pro License in PowerBI to send Pushes to POWERBI REST API, but I'm tending to think in this way):

"error": "invalid_grant",

    "error_description": "AADSTS65001: The user or administrator has not consented to use the application with ID 'xxxxxxxxxxx named 'RobertoItu'. Send an interactive authorization request for this user and resource.\r\nTrace ID: xxxxxxxxxxxxx\r\nCorrelation ID: 1d1d6112-eb97-44e8-82fa-d0970395df77\r\nTimestamp: 2020-05-21 14:38:20Z",

    "error_codes": [

        65001

    ],

    "timestamp": "2020-05-21 14:38:20Z",

    "trace_id": "xxxxxxxxxxxxxxx",

    "correlation_id": "xxxxxxxxxxxxxxxxxxxxx",

    "suberror": "consent_required"