PowerBI REST API

LABORSAL — Fri, 03 Apr 2020 18:59:15 GMT

Hello!

I'm no expert in any programming language so it's been real hard to figure this one out.

What I want to accomplish is using the PowerBI REST API which would be triggered by a flow which would refresh a few dataflows (in order) when a file is updated in a OneDrive folder.

The problems I'm running into are 2:

1) The Authentication Key seems to expire after ~30m, when I run the test in documentation and copy that key it works fine for a few mins, however after about half an hour i get a 403 no authorization reply.

2) I understand from the API documentation I can request an answer on WHEN it finishes (which would allow me to know when to start the next update) however I don't see this in the response (might a flow question but may apply here as well :P)

{ "notifyOption": "MailOnCompletion" }

Documentation found:

Dataflow Dcoumentation:

https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow

How to get Auth

https://docs.microsoft.com/en-us/power-bi/developer/embedded/get-azuread-access-token

Re: PowerBI REST API

Jayendran — Sat, 04 Apr 2020 13:22:29 GMT

Hi @LABORSAL ,

1. You have to generate the access token on the fly not like copy and pasting. Please refer https://powerusers.microsoft.com/t5/Building-Flows/Microsoft-Flow-Token-Authentication-https-graph-microsoft-com-v1/td-p/85498

2. The notifyOption is a request Body parameter, it is not a JSON output reponse

Re: PowerBI REST API

LABORSAL — Tue, 07 Apr 2020 01:03:15 GMT

This seems to be it, although getting the data is another really comlpicated topic 😛

topic PowerBI REST API in Developer

PowerBI REST API

Re: PowerBI REST API

Re: PowerBI REST API