DataSet refresh Issue in PowerBI Premium

[Anonymous]

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 min, but in case of dataset refresh it taking more than ~6hours. 

Data size in the cube is ~300 MB and here is the setting of my workspace. The user with which i'm logging to workspace is having Power BI Pro license

Please let me know what would be the possible reason for such long duration. From where i can get more insight to this issue.

I'm new to Power BI admin type work.

Please help

[v-kkf-msft]

Hi @Anonymous ,

Does your problem have been solved?

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

[Anonymous]

Thanks! for the details will definitely try out with the Power BI Capacity Metric App

[v-kkf-msft · Accepted solution]

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.