Forum Discussion

sswanson's avatar
sswanson
Frequent Visitor
6 years ago
Solved

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 performan...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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

sswanson's avatar
sswanson
Frequent Visitor
6 years ago

Thank 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