Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DataSet refresh Issue in PowerBI Premium

Hi EveryOne,   I just migrated AAS cube to a PBI Dataset in Power BI premium based workspace.    Issue i'm facing is with the refresh. In AAS the same cube was getting processed in less than 10 m...
  • v-kkf-msft's avatar
    5 years ago

    Hi Anonymous ,

     

    Interactive operations (filtering, Q&A querying, etc.) are always prioritized over background operations (refreshe, dashboard query caching, etc.). If there are insufficient resources, refreshes are added to a waiting queue until resources free up. And they can be interrupted mid-process by the Power BI service, added to a queue, and retried later on.

     

    When the refresh is slow, it can be due to several reasons:

    • Insufficient CPU.
    • Insufficient memory, resulting in refresh pausing.
    • Datasource system responsiveness, network latency, invalid permissions or gateway throughput.

    You can use Power BI Premium Capacity Metrics app to monitor the Average Refresh Duration (minutes) metric to determine a benchmark for comparison over time, and the Average Refresh Wait Time (minutes) metrics to determine average lag between average lag between the scheduled time and the start of the operation.

     

    Please refer to:

    What is Power BI Premium? 

    Optimizing Premium capacities 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.