PowerBI REST API

[LABORSAL]

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

[Jayendran · Accepted solution]

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-m...

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

[LABORSAL]

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