topic Re: Automate REST API Data Push in Developer

Automate REST API Data Push Without Service Account

cgh-greg — Mon, 16 Apr 2018 13:44:36 GMT

My goal is to periodically push data to a Power BI dataset using their REST API without user intervention.

The expalnations below for 'App Owns Data' is to configure user credentials into the application and authenticate that way, which is how I've done it so far:

https://docs.microsoft.com/en-us/power-bi/developer/get-azuread-access-token#access-token-for-non-power-bi-users-app-owns-data

I wrote an Azure WebJob that uses the credentials of a service account we created to authenticate with Azure AD and it's successfully pushing data to Power BI, but I'd like to do avoid having a service account just for this as it has cost and security implications.

Is there a way to use the Power BI REST API without user intervention and without logging in using Azure AD credentials?

Re: Automate REST API Data Push

v-micsh-msft — Mon, 16 Apr 2018 06:28:37 GMT

No, currently this is not possible.

To work with Power BI Embeded API, you will need at least one Power BI Pro user Account.

Fore more information, check the FAQ below:

FAQ about Power BI Embeded

Regards,

Michael

Re: Automate REST API Data Push

cgh-greg — Wed, 18 Apr 2018 15:20:23 GMT

@v-micsh-msftWe're looking for a Power BI Service-based solution for internal use in our organization, not one for non-Power BI-users or clients. I just want to verify that the only option is storing Azure AD credentials in the application.