Power Apps integration in Power BI Report - Excelfile

[oliviaBer]

I added a Power app in a Powerbi report. The two are linked to the same Excel table from OneDrive/Sharepoint. If I change a value from this table with the Power App, I see a change in real time. However, my graphs in the Power Bi report are not updated in real time, but only much later (1 hour). Is there a way to immediately see the changes in the report?

 

 

[oliviaBer]

Thanks @christinepayton for your answer. I even have a SQL database and linked it with a DirectQuery. However, I can only update them in Power BI Service every 15 minutes. Is that what you meant? I thought it could update itself directly

[christinepayton]

It should update immediately if you're using direct query, but I think it only checks for data when you're interacting with things - e.g. it's not going to auto-refresh the page, but if you switched from one page to another it should update because it queries when the page loads or filters are applied. 

[christinepayton]

Seeing immediate changes with the Power App visual in Power BI requires the source you're using to support direct query. Excel in OneDrive/SharePoint does not support direct query, so it will update along with your refresh schedule. You would be able to do this with a SQL or Dataverse source, though, for instance.