Add rows to dataset gives "Not API Push Dataset" error

[sinasen]

Hello,

Im building a flow which get a csv attachment from an email and adds its rows to a powerbi dataset, however I cant as I am getting the "XYZ is not API push dataset" error. How can I make the dataset a API push dataset?

Regards,

Sina

[V-lianl-msft]

Hi @sinasen ,

The table and row API works both in groups or in the default workspace base on my test. Do note that the those two API only work with the datasets created via REST API, otherwise you'll get an 404 error with a specific message "Dataset xxxxxxxx-xxx-xx-xxxx is not Push API dataset.".

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@sinasen are you trying to add data to a table through api which was created in powerbi desktop

have you tried below link for solution

https://community.powerbi.com/t5/Developer/Dataset-dataset-id-is-not-Push-API-dataset/m-p/860275