Forum Discussion

ns152154185's avatar
ns152154185
Frequent Visitor
2 years ago

Dataset schedule refresh time very slow.

Hi Everyone, I have a dataset in service which uses a dataflow as its datasource. Dataflow refresh takes about a minute but what concerning here is my dataset is taking about 40-43 mins in every ref...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ns152154185 

I have a few other ideas for you to consider:

  1. Query Optimization: Ensure your queries are efficient. Use Query Diagnostics in Power BI to identify and optimize any slow-performing steps.

  2. Data Partitioning: Split your large dataset into smaller, manageable chunks. This can help in refreshing only the necessary portions of the data.

  3. Off-Peak Scheduling: Schedule your refreshes during off-peak hours to minimize the impact on business operations and ensure more resources are available for the refresh process.

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.