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.
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
|
Solved! Go to Solution.
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.
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 |
Regards,
Xiaoxin Sheng
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.
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 |
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.