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

[FranciscaIr]

Hello everyone, 

I’m struggling with the following:
I have a Power BI report connected to a Fabric Lakehouse. The connection between the data source and the Lakehouse works perfectly, and the data updates automatically every 30 minutes.

However, I don’t see the updated data when I open the report. To load the latest information into the report, I have to press the Refresh button in the top left corner of the report.

My question is:
Is there any solution to have the report refresh automatically, so that users can access the latest data as soon as they open the report, without needing to manually press the refresh button?

Any suggestions or recommendations are welcome.

Thank you in advance for your help!

[v-sgandrathi]

Hi @FranciscaIr,

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.

Regards,
Sahasra.

[v-sgandrathi]

Hi @FranciscaIr,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you for being a part of the Microsoft Fabric Community.

[v-sgandrathi]

Hi @FranciscaIr,

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. 

Thanks for using Microsoft Fabric Community Forum.

[rajendraongole1 · Accepted solution]

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.