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
HoaiNamNguyen
Frequent Visitor

Slow Refresh - ODBC, Google BigQuery

I have slow refresh report contains 2 sources: ODBC and Google BigQuery. 

I can't figure out what leads to slow refresh. Is there any conflict between those 2 sources that could lead to slow refresh? Or where should I look into to solve this? 

Many thanksss!!!!

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

Hi @HoaiNamNguyen ,

There are 3 places where the refresh might be slow:
1.Data source
2.Power Query engine
3.Analysis Services engine

Test the below steps:

1. Please check whether there existing any step in Power Query consuming too much CPU or memory. And try to use Table.Buffer to improve the data load performance.

2. Use DAX studio/ Performance Analyzer to check out which's the most time-consuming:

Follow this blog to install the dax studio,then connect the opened pbix file in dax studio

https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

3. If your data source is online such as in onedrive or sharepoint online, they use automatic refresh in power bi service. This means no user configuration is necessary in order for the dataset to be refreshed on a regular basis. Data refresh settings are configured for you by Power BI. For online service providers, refresh usually occurs once-a-day. For files loaded from OneDrive, automatic refresh occurs about every hour for data that does not come from an external data source. While you can configure different schedule refresh settings and manually refresh, you probably don’t need to.

 

 

And refer:

https://medium.datadriveninvestor.com/my-dataset-is-taking-too-long-to-refresh-843fd8fd4a51 

 

 

Best Regards

Lucien

View solution in original post

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @HoaiNamNguyen ,

There are 3 places where the refresh might be slow:
1.Data source
2.Power Query engine
3.Analysis Services engine

Test the below steps:

1. Please check whether there existing any step in Power Query consuming too much CPU or memory. And try to use Table.Buffer to improve the data load performance.

2. Use DAX studio/ Performance Analyzer to check out which's the most time-consuming:

Follow this blog to install the dax studio,then connect the opened pbix file in dax studio

https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

3. If your data source is online such as in onedrive or sharepoint online, they use automatic refresh in power bi service. This means no user configuration is necessary in order for the dataset to be refreshed on a regular basis. Data refresh settings are configured for you by Power BI. For online service providers, refresh usually occurs once-a-day. For files loaded from OneDrive, automatic refresh occurs about every hour for data that does not come from an external data source. While you can configure different schedule refresh settings and manually refresh, you probably don’t need to.

 

 

And refer:

https://medium.datadriveninvestor.com/my-dataset-is-taking-too-long-to-refresh-843fd8fd4a51 

 

 

Best Regards

Lucien

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