Forum Discussion

wleecwleec_2's avatar
wleecwleec_2
Frequent Visitor
1 year ago
Solved

Schedule refresh issue

The Power BI dashboards were built in desktop using Import mode and contain a number of visuals. Currently I am using Power BI Pro licence type to publish it to the web.   I've experienced issues ...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    11 months ago

    Hi wleecwleec_2 


    The primary challenge relates to timing. Your Power BI Service dataset relies on an IT-managed model that refreshes at 6 AM, but this process may occasionally complete later than planned. As a result, when your dataset is set to refresh at 7:30 AM, it can begin before the source data is fully updated, leading to instances where the refresh completes without reflecting the latest data. The consistent stability of your 2 PM refresh further indicates that the refresh window is too close to the source update.

     

    To address this, adjust your morning refresh to 8:00 AM or 8:30 AM (UTC+8) to allow sufficient time after the source refresh, while maintaining the 2:00 PM refresh as your second daily run. This approach ensures both morning and afternoon refreshes remain within the Pro license limit of eight per day. Additionally, review your incremental refresh configuration to verify that the RangeStart and RangeEnd parameters are applied at the source level in a foldable step, and consider extending incremental refresh to additional tables to further enhance stability and performance


    Regards,

    Microsoft Fabric Community Support Team.



wleecwleec_2's avatar
wleecwleec_2
Frequent Visitor
11 months ago

Hi v-karpurapud, 
The issue is still there, my data has confidential info.
Can advise if I paste the image of the data model and illustrate wht i hv done?

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
11 months ago

Hi wleecwleec_2 

 

Since there is no error message in the refresh history, I am unable to determine the issue without more details. As your data contains confidential information, could you please provide a sample dataset that accurately represents the problem but excludes any sensitive or unrelated content? Please share the sample in a usable format (not as a screenshot) so it can be reviewed directly. Additionally, including the expected outcome based on this sample will help me better understand your scenario and provide a precise solution.

 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community.

 

Regards,
Microsoft Fabric Community Support Team.

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support
    11 months ago

    Hi wleecwleec_2 

    It's been a while since we last heard from you. We are ready to assist you with resolving the issue, but we need the necessary details from you. Kindly share the information required so we can better understand and address your issue.

    Thank You.