Unanswered

Dataflow update

(0) Share

Report

Posted on by TonyCasilla

I have a problem with the data flow update, since I require it to be updated every 5 or 10 minutes or as required.

The query is, is it possible to update the dataflow through a command button or another mechanism that allows the user to update the dataflow?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-peijunz-msft Microsoft Employee on at

Like (0)

Report

Hi @TonyCasilla

Would you like to refresh dataflows based on a specified frequency?
Maybe you could consider the scheduled refresh, here is the doc for your reference:
Configure scheduled refresh - Power BI | Microsoft Learn

Hope it helps.

Best regards,
Sylvia

Was this reply helpful? Yes No
Viliam Juricek 70 on at

Like (0)

Report
Hi @TonyCasilla,

yes you can have a command bar button that runs your Dataflow.
Here's how we do it in our solutions:
Create a Power Automate flow with trigger being HTTP request which just start refreshing the Dataflow you need. Once you save the Power Automate flow, you'll be able to get URL of the trigger.
Create a new JavaScript web resource that will be run on click of you command bar button and in the code just send a request to the URL of the Power Automate flow.
There are also few points you maybe want to think about, so I'm just going to put them here as well.
It is generally a good practice to save URL of HTTP request triggered Power Automates to an environmental variable and read that variable in JS running on command bar button click to get URL from current environment.
Communication to the user is also important therefore you want to provide them with some sort of message that the refreshing of the Dataflow has begun. You also maybe want to let user know when the Dataflow refresh finished. Unfortunately for that there's no action such as wait for Dataflow refresh, however there is a trigger for Power Automate on Dataflow refresh end which you can use to inform the user. For these scenarios we use something like a request log table where we store who requested the refresh and when so we always know who to notify upon completion. For notifications you generally have options to send an email (personally, I do not recommend as there is way too many emails anyway), you can send a message to user from a Power Automate bot in Teams, send a push notification to user or use in-app notification feature of model-driven apps.
You may end up with multiple users requesting refresh at the same time which is not really efficient. Solution to this might be that request table I mentioned above which would safeguard this. You could even build a logic around how frequently does it make sense to run the Dataflow and if someone requests it sooner that that period you could just inform user that data is already refreshed or is currently being refreshed.
If you would need a sample for the JS or the request table logic just let me know.
Hope this helps

Best Regards
Wiliam

Was this reply helpful? Yes No
TonyCasilla 47 on at

Like (0)

Report

@Wiliam_Juricek Hello, thanks for answering, will there be a tutorial?

Was this reply helpful? Yes No
Viliam Juricek 70 on at

Like (0)

Report

Hi @TonyCasilla, for which part you mean? Or what variant of the architecture? Since it can be really a simple script or a truly robust feature with multiple conditions being applied to the Dataflow refresh.
I could make up a simple example after I get off from work if you tell me which variant would you like to see.

BR
Wiliam

Was this reply helpful? Yes No
kent-culpepper on at

Like (0)

Report

William,

Re: the notifying an end-user upon completion of dataflow refresh, I have not been able to accomplish this successfully. See https://powerusers.microsoft.com/t5/Building-Power-Apps/Error-on-When-a-dataflow-refresh-completes/m-p/2291240#M573134

Any ideas?

Thank you.

Was this reply helpful? Yes No