Forum Discussion

hhlaine's avatar
hhlaine
Frequent Visitor
5 years ago

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

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 rel...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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