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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
VeraInSydney
Frequent Visitor

What are the factors that affect Power BI Service dataset refresh rate?

Dear community,

Just want to find out why the refresh speed of same dataset on Power BI service takes quite various time to refresh? I refreshed same dataset for 2 mins last Friday, today it took more than 40 mins. What are the factors affecting the dataset refresh speed?

 

Cheers,

VeraInSydney

1 ACCEPTED SOLUTION
Hariharan_R
Solution Sage
Solution Sage

Hi 

Factors are,

1. Premium Workspace - If your workspace is premium capacity workspace then you need to understand the traffice. The same premium capacity can be assigned to multiple workspaces. Check with Premium capacity admin and monitor the Premium Metrics to understand the memory and CPU usage on your schedule time.

 

2. Database - Check the traffice in your database side. If you are considering any RDBMS source then check with DB admin and understand any other schedules are going on and what is the allocation  for your DB account to run the query. Is there any change in the DB configuration etc..

 

3. Volumne of your data - Check the size of your dataset and make sure to apply the incremental refersh to get the high refresh speed. Also ensure query folding is happening.

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


View solution in original post

1 REPLY 1
Hariharan_R
Solution Sage
Solution Sage

Hi 

Factors are,

1. Premium Workspace - If your workspace is premium capacity workspace then you need to understand the traffice. The same premium capacity can be assigned to multiple workspaces. Check with Premium capacity admin and monitor the Premium Metrics to understand the memory and CPU usage on your schedule time.

 

2. Database - Check the traffice in your database side. If you are considering any RDBMS source then check with DB admin and understand any other schedules are going on and what is the allocation  for your DB account to run the query. Is there any change in the DB configuration etc..

 

3. Volumne of your data - Check the size of your dataset and make sure to apply the incremental refersh to get the high refresh speed. Also ensure query folding is happening.

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors