cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
engferno
Regular Visitor

Anyone figured out dataflow execution API?

I can’t find any docs on executing or updating data flows. I find it extremely annoying and concerning that I can’t:

1) programmatically invoke and find the status of dataflows 

2) store dataflow steps in source control and write API calls to update it. 

anyone figured it out? I tried to reverse engineer to no avail 

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

Hi@engferno,

Based on the issue that you mentioned, do you want to invoke a dataflow using REST API within your app?

If you want to invoke a dataflow using REST API within your canvas app, I am 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:

v-qiaqi-msft_0-1616396610540.jpeg
v-qiaqi-msft_1-1616396610470.jpeg

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

Please check the following article for more details:

Create and use dataflows in Power Apps - Power Apps | Microsoft Docs

In addition, if you want to make an HTTP POST request to call an api which would in turn refresh the dataflow, I can tell you that this is not available for Power Apps either.

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:

v-qiaqi-msft_2-1616396811678.jpeg

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

Hope it could help you.

Regards,

Qi

 

Yes thanks I’m. Familiar with the steps you mentioned. I’m looking for the feature that’s not there which is REST API. Time refreshes in an ETL chain where you need to process certain files in certain orders, or want notifications or actions after complete is not possible. I’ll add the user voice feature request 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Kudoed Authors
Users online (24,348)