Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jose_olaya
Regular Visitor

Idea --> Refresh Failed.. --> There was an error when processing the data in the dataset.

Hi there, we are facing all weeks this issue, just during monda y mornig when all management team try to get fresh information to drive his actions .. 

 

Could be possible to know which Azzure time slots are more free and recommeded to schedule on these hours to try to avoid this situation, For example we can move updates to saturdy night, or your recommend time slot, even we are open to give you freedom to perform updates in your best slot, jsut with one condition: to have our dashboard updated monday morning 9:cet . Ccould you please provide  some advise here?.. If we lost some confidence about data quality in terms of updating, we can have a issue 

 

 

All the best.

JL

 

 

 

 

:

The operation was throttled by Power BI Premium because there were too many datasets being processed concurrently

 

 

powerBI erro.JPG

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @jose_olaya ,

What type of premium license you use? AFAIK, they have limit on parallel refresh queries. (Model Refresh Parallelism)
If your premium capacity not existed enough idle threads to handle your refresh request, you will get error message about request over limit.

If this is a case, you can consider to remove unused query table from premium capacity or upgrade your license.

Spoiler
Capacity Nodes Total v-cores Backend v-cores RAM (GB) Frontend v-cores DirectQuery/Live Connection (per sec) Model Refresh Parallelism
EM1/A1 1 0.5 2.5 0.5 3.75 1
EM2/A2 2 1 5 1 7.5 2
EM3/A3 4 2 10 2 15 3
P1/A4 8 4 25 4 30 6
P2/A5 16 8 50 8 60 12
P3/A6 32 16 100 16 120 24

What is Power BI Premium?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @jose_olaya ,

What type of premium license you use? AFAIK, they have limit on parallel refresh queries. (Model Refresh Parallelism)
If your premium capacity not existed enough idle threads to handle your refresh request, you will get error message about request over limit.

If this is a case, you can consider to remove unused query table from premium capacity or upgrade your license.

Spoiler
Capacity Nodes Total v-cores Backend v-cores RAM (GB) Frontend v-cores DirectQuery/Live Connection (per sec) Model Refresh Parallelism
EM1/A1 1 0.5 2.5 0.5 3.75 1
EM2/A2 2 1 5 1 7.5 2
EM3/A3 4 2 10 2 15 3
P1/A4 8 4 25 4 30 6
P2/A5 16 8 50 8 60 12
P3/A6 32 16 100 16 120 24

What is Power BI Premium?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors