topic Re: Fail to add rows on dataset using PowerBI Rest API in Developer

Fail to add rows on dataset using PowerBI Rest API

kaushal — Thu, 01 Sep 2016 09:47:47 GMT

Hello,

I am using PowerBI Rest API to add row on the dataset that I created using PowerBI Desktop. But I am facing following error

An unhandled exception of type 'System.Net.WebException' occurred in System.dll

Additional information: The remote server returned an error: (400) Bad Request.

When I try to add rows into the dataset which has been created by Power BI Rest API itself, I don't get any error and I am able to add rows into it.

Does that mean Power BI Rest API cannot add rows to those dataset which has not been created by REST API?

Thanks

Re: Fail to add rows on dataset using PowerBI Rest API

Eric_Zhang — Sat, 03 Sep 2016 08:23:03 GMT

@kaushal

I got the same error as yours when trying to add rows via REST to a dataset created in Power BI desktop. That seems a limitation and there's already one idea Push data via API into an existing model, you can vote it up.

Re: Fail to add rows on dataset using PowerBI Rest API

ttankka — Thu, 22 Mar 2018 21:04:29 GMT

I am getting this error as well. I copied the code from the "push data into a dataset" walkthrough and it failed with the error you mentioned in the addsrows section.