Get data using Azure REST API - Post method

[cpmohanraj]

Hi All,

I am trying to build a Power BI report that would access Azure REST API ti get data factory pipeline run data.

The API document - https://docs.microsoft.com/en-us/rest/api/datafactory/pipelineruns/querybyfactory - this doesn't work from Power BI

I am able to access another call from Power BI - https://docs.microsoft.com/en-us/rest/api/datafactory/pipelines/listbyfactory

The difference between them is the former needs to be called using POST method while the latter is called using GET method

I understand that I need to pass the credentials (in the form of a token) but I am not sure how to generate this token every time I refresh the report.

Any help or reference would be greatly appreciated

[v-cherch-msft]

Hi @cpmohanraj

Here is the video for your reference.

Regards,

Cherie

[cpmohanraj]

Thanks Cherie for the video link. 

I am trying to access this data from Power BI desktop. Do you know how do you register Power BI desktop as an app in Azure AD? Should I be asking this question in Azure forum.

[v-cherch-msft]

Hi @cpmohanraj

Please refer to this article:Register an app with Azure AD.If you need further help,i would suggest you post your question here.

Regards,

Cherie