Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sswanson
Frequent Visitor

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

1 ACCEPTED SOLUTION
3 REPLIES 3

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors