DirectQuery-report performance on Service is fraction of same report in Desktop

[hhlaine]

Hi, having a DQ to Oracle, about 10 views as a source, joined in PBI model. Works nicely on Desktop, few seconds to excecute. When published to Service -> fails after several minutes with message related to exeeding resources.  Gateway OK and if I trim the same query with SQL conditions (within PowerQuery) so that it only produces few hundred rows, it works. 

- So is there something not right in settings on PBI Service / GW that makes the performance drop vs desktop?

Any ideas?

[Aymen]

Hello @hhlaine ,
are you on premium or shared capacity?

anyway try to use aggregations in your power bi desktop you can find below some advantages of using it include:

• Better query performance over big data. 
• Optimized data refresh. 
• Balanced architectures. 

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations 

you can also take a look below to try to optimise your model:
https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance 

Best Regards,
Aymen