cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft
Microsoft

Error when trying to add data via REST API to a dataset/table created via PBI desktop

I have a customer who has created a dataset with two tables using the PBI desktop. The first table contains device data that will be streamed in on an ongoing basis. The second table contains lat/lon data that will be used as reference data to join with the first table, and only infrequently updated. He now wants to programmatically add data to the first table programmatially using the REST API. This fails with the following error:

 

{
  "error": {
    "code": "InvalidRequest",
    "message": "Posting rows to this type of dataset is not currently supported. Please create your dataset by posting it through the API following the instructions on http://dev.powerbi.com."
  }

 

Is he hitting an issue with PBI in that it doesn't support writing data using the REST API to datasets created via the PBI Desktop? Is this going to be fixed (and if so, when), or is there a suitable workaround?

 

Thanks, Robert

3 REPLIES 3
Super User IV
Super User IV

Yes, I believe that is exactly what he is hitting. Probably needs to post the PBIX file up to an Azure Power BI collection and then he could add the data programatically.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hello. What do you mean by a "collection"? I just now tried to recreate the customers issue and I think I got it - although the error I got is "400 - Bad Request". Anyway, I created a dataset and table using PBIX and published it to my subscription. Then, I tried to add rows to it programmatically. This is when I get the bad request error. So, do people know if this should actually work - programmatically writing to a dataset/table that was created via PBI Desktop?

Impactful Individual
Impactful Individual

@roalexan, I get the same exception as yours when I try using Power BI REST API to add rows to dataset which was created in Power BI Desktop. I have to say that there is a limitation in the API that it is only supported to write data to datasets that were created via API.

 

There is already one feature request about on the Power BI Idea forum, you can vote it: https://ideas.powerbi.com/forums/268152-developer-apis/suggestions/6912162-push-data-via-api-into-an...

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors