Forum Discussion
Power BI Performance: Number of queries in Power Query Editor
Hi all,
A general question for the Power BI community -
I'd like to get a feel for the average number of queries that most people are working with.
I'm working on improving the performance of one of my models - just curious about what other people are doing.
Thanks!
S Swanson
sswanson , There are Best Practices to improve performance
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Relationships/td-p/712566
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567
3 Replies
- amitchandak
Super User
sswanson , There are Best Practices to improve performance
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Relationships/td-p/712566
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567Thank you so much for posting these articles Amit! 🙂
Very helpful.
To clarify - I was referring to the number of queries in Power Query, not in DAX. Sorry, I should have worded that a little better 🙂
I realize that it is probably pretty variable, and it depends on the project, but I'm wondering what the best practices were for creating multiple queries in Power Query before loading the model in Power BI. Recently, I've been working more with M in Power Query, because I can do some of the work up front and not necessarily load everything into the data model - I was thinking that I might be able to improve performance this way.
To give some background, I'm connecting to csv or xlsx files hosted on SharePoint.
Thanks again for your message,
S Swanson
v-deddai1-msftCommunity Support
Hi sswanson ,
You can also refer to https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Best Regards,
Dedmon Dai
