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?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
Below are few suggestions from my experience
- You can use indexing on database columns in mysql side
- I used CTE format for things speedup, It reduces 5,6 minutes execution/power bi loading time to 6,7 seconds.
- Used mysql views instead of stored procedures and direct queries.
- Upgraded database processor.
- Reduces inner joins on queries.
- Manage most suitable conditions for queries and select only imported ones.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0