Forum Discussion

FranciscaIr's avatar
FranciscaIr
Regular Visitor
1 year ago
Solved

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

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 perfect...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

     

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

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's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

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's avatar
    v-sgandrathi
    Icon for Community Support rankCommunity Support
    1 year ago

    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.