Power Apps integration in power bi -PowerBIIntegration.Refresh() is inconsistent in Direct Lake Mode

I don't think Direct Lake mode will get you a deterministic UX. There are random delays in the process. I would go with Direct Query to the database, not the endpoint.

Hi abhiram342 ,
Thanks for posting in Microsoft Fabric Community.
Thanks for providing all the details. From what you're describing, it seems like the issue with PowerBIIntegration.Refresh() is due to how the data is being updated in Direct Lake Mode.
As mentioned by lbendlin , since there can be random delays in propagating changes from the Fabric SQL Database to the Lakehouse, the Power BI visuals may not refresh consistently.

Possible Workaround:
You could try adding a small delay before using PowerBIIntegration.Refresh(). This gives the system extra time to make sure all changes are fully synced, making the refresh process smoother.

As lbendlin  mentioned, Direct Lake Mode may not offer a fully deterministic experience. If you're looking for more consistent results, using Direct Query directly to the database instead of the endpoint might provide a more stable connection.

Also, here's a link that discusses a similar scenario and provides some additional insights.

From Microsoft’s documentation:

Power Apps visual for Power BI - Power Apps | Microsoft Learn

Hope this helps. Please reach out for any assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Best Regards,
Vinay.