Power Bi Premium

Hi Syndicate_Admin ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Deku for the prompt response.

For the error you are facing "the dataset is too large to refresh due to timeout or memory issues" - often caused by complex models or large imported tables.

Here are some Troubleshooting steps to solve the issue:

1.Check your workspace is truly in Premium capacity:

Go to your workspace settings

Ensure the “Premium capacity” toggle is ON, and it's assigned to a dedicated capacity (like P1/P2)

2.Optimize your model:

Remove unused columns or tables

Reduce cardinality (e.g., long text fields, high-distinct columns)

Consider changing large tables to DirectQuery or Hybrid Tables

3.Split large data loads:

Use incremental refresh on large fact tables to avoid full dataset loads every time

Break up complex queries in Power Query

4.Use XMLA endpoint to check dataset size:

If you're in Premium, you can use tools like Tabular Editor or SSMS to connect via XMLA and get detailed metrics

• If everything looks right but the problem continues, contact Microsoft support with the Cluster URI and Activity ID you shared - that will help them trace it.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.