Search code examples
mysqldatabasepowerbibusiness-intelligencebi-tool

What are the parameters which effect on speed of Power BI

Which parameters affects most on executing query using PowerBI? What is important on server side? Do HDD disks slows very much and choosing SSD is much better? Is any standards that mysql DB should fulfill to to make Power Bi run faster? Is there options/settings that I can turn on/off on user site to speed up downloading data? Which functions should I avoid in writing queries?

Solution

  • Below are few suggestions from my experience

    1. You can use indexing on database columns in mysql side

    2. I used CTE format for things speedup, It reduces 5,6 minutes execution/power bi loading time to 6,7 seconds.

    3. Used mysql views instead of stored procedures and direct queries.

    4. Upgraded database processor.

    5. Reduces inner joins on queries.

    6. Manage most suitable conditions for queries and select only imported ones.