Power BI Performance: Number of queries in Power Query Editor

[sswanson]

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

[amitchandak · Accepted solution]

@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-Rel...
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-sho...

[sswanson]

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

[v-deddai1-msft]

Hi @sswanson ,

You can also refer to https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

Best Regards,

Dedmon Dai