Slow Load/RefreshResourceDemandTimephasedDataSet

[Sunnie]

Help,

I've imported Project Online data into Power BI Desktop and there is a Resource Demand TimePhased data set that takes a very long time to refresh.  It took over 2 hours to import.  Is there a way that I can make this data set refresh faster?  I've tried filtering out dates, and did a groupby , but the query change took so long that I ended up canceling that change.

Any advice would be appreciated.

[Jimmy801 · Accepted solution]

Hello @Sunnie 

I'm not using Project online but Project on SQL server with different views that makes retrieving the data very very fast. But also project online it should not take to long. I don't know what tables you are exactly querying, and I don't know how you transform it, so I'm not able to tell you anything. A general rule of thumb is to first put all your steps that a limiting the data, meaning put all possible filter steps at the beginning. I also don't know if Power BI is able to query fold to project online, I would need to investigate on that.

If you could post your query here and make some screenshots after the first few steps I could tell you a little bit more.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Sunnie]

thanks Jimmy, I did do alot of googling and figured out that is what is the problem, the data will need to come out of SQL.

[v-yingjl · Accepted solution]

Hi @Sunnie ,

You can refer these documents about optimize your data model in power bi:

1. Optimize a model for performance in Power BI  
2. Optimization guide for Power BI 
3. Power BI Performance Optimization Tips 

In addition, you can try to use incremental refresh to refresh your data, please refer: Incremental refresh in Power BI 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jimmy801 · Accepted solution]

Hello @Sunnie 

I'm not using Project online but Project on SQL server with different views that makes retrieving the data very very fast. But also project online it should not take to long. I don't know what tables you are exactly querying, and I don't know how you transform it, so I'm not able to tell you anything. A general rule of thumb is to first put all your steps that a limiting the data, meaning put all possible filter steps at the beginning. I also don't know if Power BI is able to query fold to project online, I would need to investigate on that.

If you could post your query here and make some screenshots after the first few steps I could tell you a little bit more.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy