Answered

Invoking a dataflow in PowerApps using a rest api

Like (0) Share

Report

Posted on 5 Apr 2020 11:48:14 by Community Power Pla...

I have created a Dataflow in Power Apps. I can refresh it manually but I want to invoke(refresh) it programatically maybe using Rest API. Is there any way I can do so?

Categories:

Dataflows

General Questions

All responses (3)

Answers (1)

Verified answer

v-xida-msft on 07 Apr 2020 at 01:43:40

Like (0)

Report
Re: Invoking a dataflow in PowerApps using a rest api

Hi @Anonymous ,

Yeah, you are right. If you want to send a HTTP Post to invoke the data flow in your PowerApps, I afraid that there is no way to achieve your needs.

As an alternative solution, you could consider create a custom connector based on the Power BI REST API within your PowerApps, then specify the "Refresh Dataflow" action path within this custom connector. After that, you could use the custom connector action within your canvas app to refresh your data flow.

When you specify the Authentication way for your custom connector, please configure it as below:

the Resource URL for Power BI API is following:

https://analysis.windows.net/powerbi/api

More details about getting Access Token for using Power BI API, please check the following article:

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

https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app

More details about creating a custom connector within PowerApps, please check the following video or article:

https://www.youtube.com/watch?v=dBCS1nPsDiE

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/register-custom-api

Best regards,
Community Power Pla... on 06 Apr 2020 at 15:19:48

Like (1)

Report

Re: Invoking a dataflow in PowerApps using a rest api

Hi @v-xida-msft ,

Actually I was looking to use the dataflow to update entities in my model driven app. What I wanted to do is make an HTTP POST request to call an api which would in turn refresh my dataflow. I saw that the functionality is available in Power BI.

This is what I am talking about - https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow

The similar funtionality is not available in Power Apps is what you are saying right?

Thanks,
Raj
v-xida-msft on 06 Apr 2020 at 06:40:03

Like (0)

Report

Re: Invoking a dataflow in PowerApps using a rest api

Hi @Anonymous ,

Do you want to invoke a dataflow using REST API within your canvas app?

If you want to invoke a dataflow using REST API within your canvas app, I afraid that there is no way to achieve your needs in PowerApps currently.

Currently, the dataflow REST API is not exposed within PowerApps. If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

As an alternative solution, you could configure a auto-fresh frequency for your dataflow as below:

then your data flow would be refreshed automatically in a specific recurrence.

Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-and-use-dataflows#set-the-refresh-frequency

Best regards,