How can I automatically refresh the data in a Power BI report connected to Fabric Lakehouse?

Hi FranciscaIr  - you're facing is a common one when using Power BI with real-time or frequently updated data sources like a Fabric Lakehouse. While the data in the Lakehouse updates automatically, Power BI's default behavior is to cache data until the report is refreshed manually or on a schedule.

Automatic Page refresh (APR) works only with DirectQuery or Live Connection datasets, which should apply to your Fabric Lakehouse connection.

• The minimum refresh interval depends on your licensing (1 second for Premium, 30 seconds for Pro).

Few suggestions

• If using DirectQuery, enable Automatic Page Refresh.
• If using Import mode, schedule dataset refreshes as frequently as your license allows.
• If real-time updates are critical, consider streaming datasets for dashboards or exploring Fabric's real-time capabilities.

Automatic Page Refresh in POWER BI Desktop & POWER BI Service

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

Hope this details helps.