DEV Community: Peafowl IT Solution

Query Folding and Aggregations in Power BI: Reduce Load Time by 80%

Peafowl IT Solution — Wed, 17 Jun 2026 10:09:21 +0000

Y
ou have done everything right on the surface. Your data model looks clean. Your DAX is tidy. Your visuals are minimal. And your Power BI report still takes twenty seconds to load.

If this is where you are, the problem is almost certainly not on the report page. It is happening earlier in the pipeline, in the stage where data moves from its source into Power BI, and in the stage where Power BI answers queries against that data. These are the two areas where query folding and aggregations operate. And they are the two techniques most likely to give you the dramatic performance improvement you have been looking for.

Done correctly, these techniques can reduce dataset refresh times and report query response times by 50 to 80 percent on large datasets. This blog explains how both work, how to implement them, and where they fit together in a well-built Power BI environment.

Why Reports Get Slow Before DAX Even Runs

Most performance troubleshooting in Power BI focuses on DAX and visuals. Those are valid areas to optimise. But a significant portion of slow Power BI environments are slow because of what happens before any measure is evaluated.

When a dataset refreshes, Power BI retrieves data from the source, applies the transformation steps you have defined in Power Query, and loads the result into the VertiPaq in-memory engine. If Power BI is pulling millions of raw rows across the connection, transforming them using its own processing engine rather than the database, and loading everything from scratch on every refresh, you will have a slow environment regardless of how clean your DAX is.

This is the problem query folding solves.

And even after a fast refresh, if your report visuals are generating queries against hundreds of millions of detail rows every time a user changes a filter, performance will still suffer. This is the problem aggregations solve.

Understanding both is what separates Power BI environments that stay fast as data volumes grow from those that were only ever fast when the dataset was small.

Query Folding: Making the Database Do the Work

What It Is

Query folding is the process by which Power Query translates your M transformation steps into a native query that executes directly on the data source rather than in Power BI.

When folding is active, your database server handles the filtering, joining, and transforming of data using its own optimised engine. It sends Power BI a smaller, already-processed result rather than a full raw table. Refresh times drop significantly because far less data is being processed and transferred.

When folding is not active, Power BI pulls the raw data across the connection and processes every transformation step itself. On large tables, this is dramatically slower.

How to Check Whether Folding Is Working

Open Power Query Editor in Power BI Desktop. Select any query, then right-click a step in the Applied Steps pane. If you see "View Native Query" as a clickable option, folding is active at that step. If it is greyed out, folding has broken at that point and everything from that step onward is being processed by Power Query rather than the source.

This single check is one of the most revealing diagnostics in the entire Power BI toolset. Most developers who look at it for the first time discover that folding is broken much earlier in their transformation chain than they expected.

What Breaks Folding

Several common Power Query patterns silently break folding without displaying any warning.

Adding an index column breaks folding immediately because there is no SQL equivalent for a sequentially generated row index. Adding custom columns that use M functions without SQL counterparts breaks folding at that step. Merging queries across different data sources breaks folding because no single database engine can execute a cross-source join natively. Pivoting and unpivoting columns frequently breaks folding depending on the source.

The practical guidance is to apply your most common and essential transformations first, particularly row filters and column selections, because those steps will fold. Place any steps that break folding as late in the chain as possible. Everything before a non-foldable step still folds, so the order of your steps has a direct impact on how much work the database handles versus how much Power BI handles.

For transformations that cannot be made to fold through Power Query, consider pushing them upstream. A SQL view, stored procedure, or materialised table in your database can deliver the pre-transformed result to Power BI, which then reads it with clean folding applied to a simple select query.

Folding and Incremental Refresh

One reason query folding matters beyond refresh speed is its relationship with incremental refresh.

Incremental refresh allows Power BI to refresh only the most recent partitions of a dataset rather than reloading every row on every refresh. For large fact tables this can reduce refresh time from hours to minutes. But incremental refresh requires query folding to function. Power BI generates date range filter conditions that need to be passed to the data source. If folding is broken, those conditions cannot be pushed to the source and Power BI falls back to loading the full table before filtering, which defeats the entire purpose.

If you have incremental refresh configured but are not seeing the expected improvement, check whether folding is intact on your date filter steps. Restoring folding in the right place will often unlock the refresh time reduction immediately.

Aggregations: Making Queries Faster at Scale

What They Are

Even with perfect query folding and a fast refresh, there is still the question of what happens when a user opens a report on a dataset containing 500 million rows.

Every time a visual renders, Power BI generates a query against your data model. If that query requires scanning a very large fact table to calculate a sum or average, even the fast VertiPaq engine has physical limits at extreme data volumes.

Aggregations solve this by pre-computing the results of common queries and storing them in a much smaller summarised table. Instead of scanning 500 million transaction rows to calculate total revenue by region and month, Power BI reads from an aggregation table that already contains that result. A table that might have 10,000 rows instead of 500 million answers the query in milliseconds.

How They Work in Practice

You create a summarised version of your fact table at the granularity your reports most commonly query. If most of your dashboards group by year, region, and product category, your aggregation table holds pre-computed totals at that level.

You add this table to your Power BI model alongside the detail fact table and configure aggregation mappings that tell Power BI which columns correspond between the two tables and which aggregation function each measure uses.

From that point, Power BI automatically routes incoming queries. If the query can be answered from the aggregation table, it uses the aggregation table. If the query requires more granularity than the aggregation table holds, it falls through to the detail table transparently. The user sees the correct result either way. But the vast majority of common report interactions are answered from the small, fast aggregation table rather than the large detail table.

Getting the Granularity Right

The value of an aggregation table depends entirely on how closely its granularity matches what your reports actually query. An aggregation table built at a level that is either too coarse or too fine for your reports will not deliver the performance benefit you are looking for.

Before building an aggregation table, spend time analysing the filters, groupings, and drill levels your reports use most frequently. Build the aggregation table to match that pattern. If different user groups have fundamentally different reporting needs, you may need aggregation tables at multiple levels to serve each group efficiently.

Using Both Together

Query folding and aggregations work at different stages of the Power BI pipeline and they complement each other directly.

Query folding reduces the cost of getting data into Power BI by pushing transformation work to the source and enabling incremental refresh to minimise what is loaded on each cycle. Aggregations reduce the cost of answering queries within Power BI by routing common report interactions to pre-computed results rather than scanning large detail tables.

An environment with both configured correctly is fast at every stage. Data flows in efficiently. Reports respond quickly. The architecture scales as data volumes grow because performance is built into the design rather than maintained by keeping the dataset artificially small.

This is the kind of architecture that separates Power BI environments that perform reliably in production from those that were only ever fast in a development environment with limited sample data.

Getting This Right With the Right Partner

Query folding and aggregations are not surface-level configurations. They require a genuine understanding of how Power BI's query pipeline works across every stage, from the source database through Power Query, through the VertiPaq engine, and through to the DAX evaluation layer.

Getting aggregations wrong in particular does not just fail to improve performance. It can introduce subtle situations where queries fall through to the wrong layer and return inaccurate results, which is significantly more damaging than a slow report.

Peafowl IT Solution is a certified Microsoft consulting partner whose Power BI team brings deep technical expertise in exactly this kind of performance architecture. They work with businesses across the US and UK to audit existing Power BI environments, identify where performance is being lost, and implement the structural improvements that produce lasting results.

For organisations building new Power BI environments, their implementation approach builds these standards in from the design phase so performance is never a remediation exercise after go-live.

If your Power BI environment is not performing the way it should, or if you want to build on the right foundation from the start, you can explore their services and book a free consultation at peafowlit.com/power-bi-consulting-services.

Key Takeaways

Query folding pushes your Power Query transformation work back to the data source, dramatically reducing refresh times and unlocking incremental refresh. Check it by right-clicking steps in Power Query and looking for "View Native Query." Preserve it by ordering your steps carefully and pushing complex transformations upstream to views or stored procedures.

Aggregations pre-compute the results of your most common report queries in a small summarised table, allowing Power BI to bypass large detail scans for the vast majority of user interactions. Design them around the granularity your reports actually query and let Power BI route transparently between the aggregation table and detail table as needed.

Together, they address performance at every stage of the pipeline. If your Power BI environment is slow, these are the two techniques most likely to produce the improvement you are looking for.

Want a Power BI environment built to perform at scale? Peafowl IT Solution delivers certified Microsoft Power BI consulting and performance optimisation services for organisations across the US and UK. Learn more at peafowlit.com/power-bi-consulting-services.

Leading PowerApps Development Company for Custom Business Solutions

Peafowl IT Solution — Mon, 18 May 2026 11:28:14 +0000

In today’s digital-first business environment, organizations need agile and scalable applications to streamline operations, improve collaboration, and increase productivity. Traditional software development methods are often time-consuming, expensive, and difficult to maintain. This is why businesses are rapidly adopting Microsoft PowerApps to build custom applications quickly and efficiently.

As a leading provider of PowerApps solutions, Peafowl IT PowerApps Development Services helps organizations create tailored business applications that automate workflows, simplify processes, and support digital transformation. Our custom PowerApps development services are designed to meet the unique operational needs of businesses across industries.

What Is Microsoft PowerApps?

Microsoft PowerApps is a powerful low-code development platform that enables businesses to create custom applications without extensive coding. It allows organizations to automate processes, connect data sources, and build user-friendly applications for both web and mobile platforms.

PowerApps integrates seamlessly with:

Microsoft 365
SharePoint
Dynamics 365
Power BI
SQL Server
Azure
Third-party business systems

With PowerApps, businesses can rapidly develop applications for inventory management, employee tracking, approval workflows, customer relationship management, field operations, and much more.

Why Businesses Need Custom PowerApps Solutions

Every organization has unique workflows and operational requirements that off-the-shelf software cannot fully address. Custom PowerApps solutions allow businesses to build applications specifically designed around their processes and goals.

Professional PowerApps development services help organizations:

Automate repetitive tasks
Reduce manual data entry
Improve operational efficiency
Increase employee productivity
Centralize business data
Enhance collaboration across teams
Accelerate digital transformation
Reduce application development costs

Custom business applications improve flexibility, scalability, and overall business performance.

Our PowerApps Development Services

At Peafowl IT PowerApps Development Services, we deliver end-to-end PowerApps development solutions tailored to your business requirements.

Custom PowerApps Development

We build fully customized applications that streamline business processes and improve workflow management. Our apps are scalable, secure, and easy to use across devices.

Canvas App Development

Our team creates visually engaging Canvas Apps with responsive interfaces designed for web, tablet, and mobile experiences.

Model-Driven App Development

We develop robust model-driven applications powered by Microsoft Dataverse for businesses that require advanced data management and process automation.

Workflow Automation with Power Automate

We integrate PowerApps with Microsoft Power Automate to automate approvals, notifications, document processing, and repetitive operational tasks.

SharePoint and Microsoft 365 Integration

Our solutions integrate seamlessly with SharePoint, Teams, Outlook, Excel, and other Microsoft tools to create a connected digital workspace.

Enterprise Mobility Solutions

We develop mobile-ready business applications that allow employees to access data and workflows anytime and anywhere.

Benefits of Choosing a Leading PowerApps Development Company

Faster Application Deployment

PowerApps enables businesses to develop and launch applications quickly using low-code technology, reducing development timelines significantly.

Cost-Effective Development

Compared to traditional software development, PowerApps lowers development and maintenance costs while delivering high-performance applications.

Scalable Business Applications

Custom PowerApps solutions are designed to grow alongside your business needs and operational expansion.

Enhanced Productivity

Workflow automation and centralized applications reduce manual work and improve employee efficiency.

Secure and Reliable Platform

Built on Microsoft’s cloud infrastructure, PowerApps offers enterprise-grade security, compliance, and data protection.

Industries We Serve

Our PowerApps development solutions support organizations across multiple industries, including:

Healthcare
Manufacturing
Retail and E-commerce
Finance and Banking
Logistics and Transportation
Education
Real Estate
IT and Technology

We understand industry-specific challenges and create customized solutions that improve business operations and efficiency.

Why Choose Peafowl IT for PowerApps Development?

Businesses trust Peafowl IT PowerApps Development Services because of our expertise, innovation, and commitment to delivering scalable digital solutions.

Experienced Power Platform Experts

Our certified developers have extensive experience building custom applications using Microsoft Power Platform technologies.

Tailored Business Solutions

We design applications specifically around your business workflows, operational challenges, and long-term objectives.

Seamless Integration

Our PowerApps solutions integrate smoothly with your existing systems and enterprise infrastructure.

End-to-End Development Support

From consultation and development to deployment and maintenance, we provide complete PowerApps development services.

Future-Ready Business Applications with PowerApps

As businesses continue to embrace digital transformation, low-code platforms like Microsoft PowerApps are becoming essential for improving agility and operational efficiency. Organizations that invest in scalable business applications can respond faster to market changes, improve customer experiences, and optimize internal processes.

With Peafowl IT PowerApps Development Services, businesses can modernize operations through intelligent workflow automation, mobile-ready applications, and connected business systems.

Conclusion

Choosing a leading PowerApps development company is essential for businesses looking to build scalable and efficient custom applications. From workflow automation and enterprise mobility to data integration and process optimization, PowerApps provides the flexibility businesses need to grow and innovate.

Partner with Peafowl IT PowerApps Development Services to create powerful custom business solutions that drive productivity, efficiency, and long-term success.

Power BI Consulting Services for Growing Businesses

Peafowl IT Solution — Mon, 27 Apr 2026 09:19:12 +0000

Power BI Consulting Services for Growing Businesses
Managing business data doesn’t have to be overwhelming. Our Power BI consulting services help organizations turn complex data into clear, actionable insights with interactive dashboards and real-time reporting.
Designed for modern businesses, our solutions simplify data management and improve decision-making without the need for complex infrastructure. We connect multiple data sources into one unified view, helping you track performance, identify trends, and make faster business decisions.
Our experts also automate reporting processes, reducing manual work and ensuring accurate, up-to-date insights for your team.

Key features include:
• Custom dashboard creation
• Real-time data visualization
• Data integration from multiple sources
• Automated reporting and data refresh
• Performance optimization

The intuitive dashboards make it easy for teams to access and understand data from any device, improving efficiency and collaboration.

Learn more:
https://peafowlit.com/power-bi-consulting-services/

Workplace Health and Safety Reporting App

Peafowl IT Solution — Mon, 20 Apr 2026 05:15:51 +0000

Workplace Health and Safety Reporting App
Efficient safety reporting is essential for maintaining a safe and compliant workplace. Our Workplace Health and Safety Reporting App enables organizations to quickly capture incidents, hazards, and near-miss reports in one centralized platform.
Designed to streamline safety reporting processes, the app helps teams improve visibility into workplace risks while ensuring accurate and organized safety records.

Key features include:
• Quick incident, hazard, and near-miss reporting
• Centralized safety reporting and record management
• Digital forms for inspections and safety observations
• Automated alerts for follow-up actions and corrective measures
The user-friendly interface allows employees and safety teams to report issues easily from any device, helping organizations respond faster and strengthen workplace safety practices.

Learn more about modern safety tools:
https://peafowlit.com/health-and-safety-apps/

Health and Safety Risk Assessment App

Peafowl IT Solution — Thu, 19 Mar 2026 11:15:49 +0000

Health and Safety Risk Assessment App
Identifying and managing workplace risks is key to preventing incidents and ensuring a safe environment. Our Health and Safety Risk Assessment App helps organizations systematically assess, track, and mitigate risks across their operations using a centralized digital platform.
Designed to streamline risk management processes, the app empowers safety teams to proactively address hazards and maintain compliance with workplace safety standards.

Key features include:
-Risk identification and hazard assessment tracking
-Digital safety inspections and assessment forms
-Centralized documentation for corrective actions and follow-ups
-Automated alerts for high-risk items and pending assessments

The intuitive interface allows employees, supervisors, and safety managers to complete risk assessments from any device, helping organizations reduce workplace hazards and maintain a safer, more compliant environment.

Learn more about modern safety tools:
https://peafowlit.com/health-and-safety-apps/

Low-Code App Development Using Microsoft Power Apps and Microsoft Dataverse

Peafowl IT Solution — Wed, 11 Mar 2026 12:30:24 +0000

Streamlined Low-Code Development Powered by Microsoft Power Apps and Microsoft Dataverse
Low-Code App Development Using Microsoft Power Apps and Microsoft Dataverse leverages the full power of Microsoft's low-code platform to simplify enterprise application development. The combined solution centralizes business data and app logic, making it easier for organizations to build scalable solutions and maintain data integrity across the organization.

Expert-Led Tools for Data-Driven App Development
Developed with industry-standard low-code and data management practices, this approach helps organizations efficiently build apps, manage relational data, and ensure consistent business logic across all applications.

Top benefits include:
• Unified data management using Microsoft Dataverse for centralized, scalable business data storage
• Low-code app development with automated workflows, business rules, and real-time data integration
• Secure platform foundation through proactive governance, role-based access, and compliance controls

Trusted, Integrated Solution for Modern App Development
By fully integrating with Microsoft tools such as Teams, SharePoint, and Power Automate, Low-Code App Development using Power Apps and Dataverse ensures secure, scalable, and enterprise-ready application delivery across the organization.

EHS Software M365 for Safety Management

Peafowl IT Solution — Fri, 13 Feb 2026 05:12:31 +0000

Streamlined EHS Management Powered by Microsoft 365

EHS Software M365 leverages the full power of Microsoft 365 to simplify environmental, health, and safety (EHS) management. The platform centralizes key safety processes, making it easier for organizations to maintain compliance and promote a safe working environment.

Expert-Led Tools for Safety and Compliance

Developed with industry-standard EHS practices, this software helps organizations efficiently manage incidents, assess risks, and ensure regulatory obligations are met.

Top benefits include:
• Incident reporting and assessments for fast, accurate capture and evaluation of workplace events
• Compliance tracking with automated workflows, audit-ready reports, and regulatory alignment
• Safe environment focus through proactive monitoring, hazard mitigation, and safety culture support

Trusted, Integrated Solution for Modern Workplaces

By fully integrating with Microsoft 365 tools such as Teams, SharePoint, and Power BI, EHS Software M365 ensures secure, centralized, and actionable EHS management across the organization.

EHS Safety Software for Risk and Compliance

Peafowl IT Solution — Fri, 13 Feb 2026 05:08:55 +0000

Minimize Hazards and Strengthen Compliance

EHS Safety Software helps organizations reduce workplace hazards, maintain compliance, and foster a proactive safety culture. Designed with industry best practices in mind, the software provides teams with tools to manage safety risks efficiently and effectively.

Expert Tools for Monitoring and Incident Management

Built for organizations seeking reliable EHS oversight, this solution supports incident tracking, performance monitoring, and regulatory compliance, enabling faster response and informed decision-making.

Key strengths include:
• Safety performance monitoring with dashboards and metrics to track trends and improvements
• Incident management for reporting, investigation, and resolution of workplace events
• Regulatory tracking to ensure adherence to safety standards and audit readiness

Trusted Platform for Safer Workplaces

By combining automation, real-time monitoring, and compliance tools, EHS Safety Software empowers organizations to reduce risks, improve safety performance, and build a strong safety-first culture.

Health and Safety Management Software Solutions

Peafowl IT Solution — Tue, 27 Jan 2026 13:45:05 +0000

Building Compliant and Safer Workplaces
Health and Safety Management Software helps organizations create and maintain compliant workplaces by centralizing safety tracking, audits, and governance processes. Designed around real-world health and safety practices, the software supports continuous improvement and promotes a strong, organization-wide safety culture.

Expertise-Driven Compliance and Process Management
Built to align with recognized health and safety standards and regulatory frameworks, the software enables teams to manage obligations efficiently while reducing manual effort and operational risk.

Essential functions include:
• Incident and audit tracking to capture, manage, and review safety events and inspection results
• Regulatory compliance tools that support reporting, documentation, and audit readiness
• Process streamlining through automated workflows, notifications, and standardized procedures

Trusted Platform for Long-Term Safety Performance
By providing accurate visibility, structured controls, and reliable reporting, Health and Safety Management Software empowers organizations to improve compliance, reduce incidents, and embed safety as a core business value.

Top Power Apps Development Firms in the US (2026): Navigating the Post-InfoPath Era

Peafowl IT Solution — Mon, 19 Jan 2026 14:08:03 +0000

As we move through 2026, the Microsoft Power Platform ecosystem has reached a critical turning point. With the final retirement of legacy tools like InfoPath, enterprises are no longer just "digitizing"—they are undergoing a massive architectural shift toward AI-native, low-code environments.
Choosing the right partner is essential for maintaining business continuity and leveraging the latest advancements in Microsoft Copilot. Here are the top Power Apps development firms leading the market in 2026.

1. Peafowl IT Solution

Peafowl IT Solution has solidified its position as a top-tier specialist in 2026, particularly for organizations facing the "InfoPath Cliff." As Microsoft officially ends support for InfoPath this year, Peafowl IT has become the go-to partner for migrating complex legacy forms into modern Power Apps environments.
Core Strengths: Expert-led InfoPath to Power Apps migration, AI-native canvas apps, and model-driven solutions.
Specialized Offerings: Their custom tools for visitor management and field service automation are highly rated for their seamless integration with Microsoft Copilot Studio.
Why They Lead: They focus on "future-proofing" applications, ensuring that automated workflows are built with 2026-standard governance and security.

2. Avanade

A joint venture between Accenture and Microsoft, Avanade remains a dominant force for global enterprise deployments. In 2026, they are the preferred choice for massive-scale digital transformations that require deep integration across Azure, Dynamics 365, and the Power Platform.

3. Cynoteck Technology Solutions

Cynoteck continues to excel as a certified Microsoft Solution Partner. They have carved out a significant niche in the healthcare and manufacturing sectors, providing end-to-end digital transformation that prioritizes data compliance and industry-specific regulatory standards.

4. Quisitive

Focused on the North American market, Quisitive is a premier partner for mid-to-large organizations. Their 2026 strategy centers on modernizing legacy business processes and establishing high-level governance frameworks, helping companies manage "citizen development" without compromising security.

5. PowerObjects (HCLTech)

Renowned for its agile development methodology, PowerObjects (an HCLTech Company) is a leader in high-impact training and deployment. Their focus in 2026 is on optimizing sales and field operations through real-time data visualization and mobile-first Power Apps.

6. EPC Group

With decades of experience, EPC Group specializes in long-term Power Platform strategy. They are particularly effective at integrating IT infrastructure with low-code tools, ensuring that new Power Apps align perfectly with existing enterprise architecture.

Vidi Corp Vidi Corp has gained traction in 2026 for streamlining business operations through tailored Microsoft 365 integrations. They are known for creating lightweight, highly efficient tools that solve specific operational bottlenecks for growing businesses.

Key Trends Defining Power Apps in 2026

If you are looking for a development partner this year, ensure they are proficient in these three 2026 pillars:

1. The "InfoPath Cliff" Support The 2026 deadline for InfoPath has created an urgent need for migration. The best firms, such as Peafowl IT Solution, offer comprehensive migration audits to ensure that critical data and complex logic aren't lost during the transition to Power Apps.
1. AI-Native Development In 2026, AI is no longer an "add-on." Modern Power Apps are built with Microsoft Copilot Studio at their core. This allows apps to handle natural language processing and autonomous tasks, making them more intuitive for the end-user.
1. Centers of Excellence (CoE) As low-code adoption scales, so does the risk of "shadow IT." Top firms now prioritize the establishment of a Center of Excellence (CoE) to manage security, compliance, and environment routing at an enterprise scale.

Final Verdict

For large-scale global shifts, Avanade remains the titan. However, for specialized, high-agility projects—specifically those involving legacy modernization and AI integration—Peafowl IT Solution is the standout choice for 2026.

EHS Software M365

Peafowl IT Solution — Fri, 16 Jan 2026 13:45:18 +0000

Streamlined EHS Management Powered by Microsoft 365
EHS Software M365 leverages the full power of Microsoft 365 to simplify environmental, health, and safety (EHS) management. The platform centralizes key safety processes, making it easier for organizations to maintain compliance and promote a safe working environment.
Expert-Led Tools for Safety and Compliance
Developed with industry-standard EHS practices, this software helps organizations efficiently manage incidents, assess risks, and ensure regulatory obligations are met.
Top benefits include:
• Incident reporting and assessments for fast, accurate capture and evaluation of workplace events
• Compliance tracking with automated workflows, audit-ready reports, and regulatory alignment
• Safe environment focus through proactive monitoring, hazard mitigation, and safety culture support
Trusted, Integrated Solution for Modern Workplaces
By fully integrating with Microsoft 365 tools such as Teams, SharePoint, and Power BI, EHS Software M365 ensures secure, centralized, and actionable EHS management across the organization.