Forum Discussion

kavi_Ruksh99's avatar
kavi_Ruksh99
Regular Visitor
1 year ago
Solved

power bi refresh

Hi all,   We have power bi pro license in my company and i have published my dashboards in power bi service and scheduled refresh times.    But in some hours refresh get failed and some hours it ...
  • rajendraongole1's avatar
    1 year ago

    Hi kavi_Ruksh99  - Go to Power BI Service → Dataset → Refresh History and check the specific error message for failed refreshes. Common errors include:

    Timeout issues

    Memory constraints

    Gateway issues

    Authentication failures

    Suggestion: Remove unnecessary columns & tables.Refresh only new data instead of the full dataset.Ensure efficient filtering & aggregation.

    If multiple datasets refresh at the same time, try staggering refresh schedules to avoid high server load.

     

    some resource links:

    Troubleshoot refresh scenarios - Power BI | Microsoft Learn

    Increase timeout of gateway - Scheduled refresh fa... - Microsoft Fabric Community

     

  • V-yubandi-msft's avatar
    1 year ago

    Hi kavi_Ruksh99 ,

    Thank you for reaching out to the Fabric Community Support. rajendraongole1 , I appreciate your response. I'd like to add a few more suggestions to enhance the refresh process.

    1. Identify the specific error message for more precise troubleshooting.
    2. Ensure query folding is enabled and avoid unnecessary transformations in Power Query.
    3. Refresh only new or changed data to enhance efficiency instead of performing full refreshes.
    4. Verify that the latest version is installed and connected properly.
    5. If your dataset is large or refreshes take too long, consider using Premium Per User (PPU) for increased capacity.

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly

     

  • rohit1991's avatar
    1 year ago

    Hi kavi_Ruksh99 ,

    If your scheduled refreshes in Power BI Service are failing intermittently, even with a Power BI Pro license, it’s often due to issues with the data source connection, gateway reliability, or network instability during specific time windows. Make sure the data gateway (if you're using on-premises data) is correctly installed, configured, and updated.

     

    You can also check the refresh history for detailed error messages, which often indicate whether the failure is due to timeouts, credential issues, or resource limitations. Additionally, avoid scheduling multiple dataset refreshes at the same time, as overlapping refreshes can strain system resources and lead to failures. Staggering the refresh schedule slightly and ensuring the data gateway is always online can help improve consistency.