topic Re: what is difference between using API and pushing the json data in powerBI or registering through in Developer

what is difference between using API and pushing the json data in powerBI or registering through app

khush19 — Tue, 30 Jul 2019 09:38:10 GMT

Hi,

I am new to powerBI.I need to implement Real time reports in PowerBI.

In the initial Analysis,I came across there are many ways to do it.but in our organization we want to implement via writing .net application and I am confused between below mentioned items.

We can register our app and then write code to push the data in PowerBi using Power Bi Rest API ,something like mentioned in he link https://thstechbit.blogspot.com/2018/01/sample-app-to-push-data-to-power-bi.html .As in Push dataset we can have multiple tables,how we can do modelling in this ,as this is happening at powerBI service where we dnt have Modelling tab?
We can also create dataset using 'real time streaming in Power BI'where we have
API option in PowerBi and create Json structure and then create console application which will populate the data.Something like https://www.sqlshack.com/real-time-streaming-in-power-bi/ Can we use Rest API for this?

So what is the difference between both?

Thanks in advance

Re: what is difference between using API and pushing the json data in powerBI or registering through

v-diye-msft — Wed, 31 Jul 2019 09:36:15 GMT

Hi @khush19

1. If you'd like to model the dataset in the service, please use the desktop to connect : Get Data>Power Bi dataset, then publish it after modelling.

2. You may refer to:http://www.microsofttrends.com/2015/02/17/pushing-data-into-power-bi-preview-using-the-new-rest-api-part-1/

3. When Historic data analysis is disabled (it is disabled by default) using the Streaming Dataset UI (that is the second method you indicated above), you'll create a streaming dataset . When Historic data analysis is enabled, the dataset created becomes both a streaming dataset and a push dataset. This is equivalent to using the Power BI REST APIs to create a dataset with its defaultMode set to pushStreaming. All requests to REST APIs are secured using Azure AD OAuth. For streaming datasets created using the Power BI service UI, as described in the previous paragraph, Azure AD authentication is not required.

Re: what is difference between using API and pushing the json data in powerBI or registering through

khush19 — Thu, 01 Aug 2019 09:14:49 GMT

Thanks diye,

Correct me if I am wrong ,to use Power BI REST APIs we need to register through app and get secured via Azure AD authentication.So for streaming dataset created through Power BI service,we cann't use Power BI REST APIs if we are writing any console application?

Thanks in advance

Re: what is difference between using API and pushing the json data in powerBI or registering through

v-diye-msft — Thu, 01 Aug 2019 10:15:01 GMT

Hi @khush19 ,

If you want to get the power bi embeded token, you need to register an app and then get secured via Azure AD authentication, but you just wanna use the rest API in service, just get Azure AD authentication token is enough.

we can use the Rest API for streaming dataset.