Forum Discussion

dpombal's avatar
dpombal
Post Partisan
3 years ago

Power BI Embedded slow performance

Hi all,

I have a customer with 1000 users, and has strong problems at peak hours using reports embedded using A4 capacity.

Is there any tool to improve performance or check what's wrong.

  • 300 users per hour
  • 800-1000 different users in a day.

 

How can we tune performance...o assess the capacity required for this environment for 1000 users and achieve good performance.

Regards

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi dpombal 

     

    What I would first suggest to make sure you have your data in a star schema.

    Then make sure that you only have in the columns that are actually required.

    Finally make sure that your DAX is as efficient as possible.

    The above can be used with DAX Studio and Tabular Editor using the Best Practise Analyzer.

     

    Once that is all done I would then use Log Analytics to see what queries are being run against your reports. You can then see which queries are taking a lot time and see if there is a way to optimize them?