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

Fail to add rows on dataset using PowerBI Rest API

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

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

@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.

 

 
2 REPLIES 2
Moderator Eric_Zhang
Moderator

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

@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.

 

 
ttankka Frequent Visitor
Frequent Visitor

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

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.