Reply
Frequent Visitor
Posts: 10
Registered: ‎09-06-2016

Push data through API

[ Edited ]

Today i continue my adventure trying to use Power BI with "live" data. Or something close to this.

 

Im following this tutorial

https://powerbi.microsoft.com/documentation/powerbi-developer-walkthrough-push-data/

 

Based on what i see using the sample of this application for awhile, please, correct me if i'm wrong.

 

- Push data only works for datasets created through API.

If i already have a dataset created, even the GetTables method will return a "Not Implemented" error.

 

- If so, what is the purpose of this tutorial? I cant see where i can use a dataset created through this API? How can i link a report to a dataset created here? What is the correct place to consume a dataset created through?

 

 

--EDITED--

 

I found this topic on SO. That was not by me, but i believe we are tring the same thing:

http://stackoverflow.com/questions/39390313/power-bi-api-push-data-to-an-existsing-dataset-from-powe...

 

 

Moderator
Posts: 1,303
Registered: ‎03-06-2016

Re: Push data through API

@jhonatas

It seems that REST APIs can only manipulate the datasets and tables also created via REST APIs.
You can check this idea Push data via API into an existing model and vote it up.

Based on my understanding, so far the purpose might be simple, you could create report in Power BI Service and add rows as refreshing via REST API.


Highlighted
vth Frequent Visitor
Frequent Visitor
Posts: 2
Registered: ‎02-06-2017

Re: Push data through API

Hi Jhonatas, I agree with you. It works fine when PUSHing into Power BI Service report, where the dataset is created through Power BI API. However, it is not possible to use API method AddRows to datasets which were not created via API. At least, this is what I have experienced so far. I am able to GET the dataset, but its "addRowsAPIEnabled": false is blocking to PUSH the data via the Power BI API.

 

The problem in my case is that it is not possible to embed Power BI Service report using the Power BI REST API & Azure AD. I can only embed it using iFrame, but then everyone in the world would be able to access this report. Therefore I would like to embed the report using Azure AD and Power BI REST API (Power BI Embedded).

 

Has anyone managed to PUSH data into embedded Power BI report using Power BI REST API and Azure AD?

What about PUSHing the data into .pbix files?

Maybe someone has managed to change "addRowsAPIEnabled": false to "addRowsAPIEnabled": enabled for the datasets created via PowerBI Desktop or Service (not API).

 

Please share any other suggestions for the following scenario.

 

Thank you in advance.