Forum Discussion
Error when trying to add data via REST API to a dataset/table created via PBI desktop
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.
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?
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-existing-model
