Forum Discussion
Helper IIPower Bi Push not on exisiting dataset possible
Hello, I was able to create a dataset and push data to the new created dataset (as described in the tutorial).
But is Power BI not able to push to a dataset that I have imported in my Power BI Service via a pbix file? Because as I do that, I am getting an error
Just ran into the same issue and did some research and it looks like it is a fairly common issue.
- https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9366600-update-rows-rest-api
- http://stackoverflow.com/questions/39390313/power-bi-api-push-data-to-an-existsing-dataset-from-power-bi-desktop
Have asked the Dev Team to look into adding this to their backlog...but no promises
6 Replies
- Greg_Deckler
Community Champion
Hmm, haven't tried that one but it wouldn't surprise me if that were the case. I am assuming here that in the Service you did "Get Data" and then pointed it to a PBIX file and imported it. And then you opened the PBIX file in Desktop and tried to overwrite it using "Publish"? What is the error that you are getting?
MbProgNo, first at all I imported my data in Power BI Desktop and did all the modelling, which have been a lot of work and complicated. Then I imported the pbix file in Power Bi Service. Now I want to update one table in the dataset with Power BI API and push data from a source to it, to show live data on my dashboards. But it didn't work.
Then to test what the problem is I created a very simple dataset with just one table (and three fields) with Power BI API and pushed data on it, which of course works.
Then I created exactly the same dataset and table in Power BI Desktop (table with just three fields) and exported it and imported it in Power BI Service. Then I tried to push the same data to it. But I recieve error message: the remote server returned an error (400) bad request.
So does it not work in Power BI?
- Greg_Deckler
I'm confused by your wording with "importing". The process I follow is to create a PBIX file in Desktop, use File | Publish to publish it to the Service. I can then, later, update the report and use File | Publish to publish the file again to the Service, it recognizes that there is a Dataset, etc. with the same name and asks me if I want to replace it. I indicate yes and it updates the dataset. Definitely works, I've done it dozens if not hundreds of times.
