PowerBIIntegration.Refresh() sometimes not work

[summer025]

What I do:

1. Create a PowerBI report in PowerBI Desktop, publish to Power BI service.

2. On Power BI service ,create a PowerApp embed in the PowerBI.

3. In PowerApp,there is a button which call PowerFlow to update data in SQLServer.

Expected:The PowerBI table should refresh

My problem is: On by button OnSelect event, I use 'PowerBIIntegration.Refresh();' to refresh the PowerBI table,sometimes successfuly refresh, but sometimes the table not refresh.

My Button OnSelect Event:
If(
Delete.Run(
param1,
param2
),
Notify(
"Records updated successfully ",
NotificationType.Success,
1500
),
Notify(
"Records not updated",
NotificationType.Error
)
);
PowerBIIntegration.Refresh();

[v-robertq-msft]

Hi, @summer025 

I’m not familiar with Power App functions. If you use PowerBIIntegration.Refresh() function, you must use a source that supports DirectQuery and the data connection must be created using the DirectQuery method.

Here are some cases linked to this issue, you can take a look:

https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerBiIntegration-Refresh-is-not-working/td...

https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerBIntegration-Refresh-not-working/m-p/39...

For more useful help, I suggest you to open a case in the Power App community and @ some top users so that more experts can see it and help you in advance.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.