Unanswered

Invoking a dataflow in PowerApps using a rest api

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-xida-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No