Call Us Today! 1.800.895.3254
[email protected]
Consulting & Advisory
Consulting / Advisory helps business and IT leaders make better decisions and turn strategy into execution-ready initiatives. Most engagements start with a Discovery Initiative to confirm outcomes, and build a roadmap.
Learn About Consulting
Data & AI
Data & AI delivers modern data platforms, analytics, and practical AI assistants built on enterprise-grade cloud tools. Integent helps you govern, deploy, and drive adoption so solutions stick and scale across your organization.
Learn About Data & AI
Support
Support keeps your solution stable, secure, and aligned with day-to-day operations. We combine functional and technical expertise with proactive monitoring, preventive maintenance, and 24/7 coverage for critical incidents.
Learn About Support
Microsoft Planner Premium
Leverage proven knowledge and experience to design and deploy Microsoft Planner Premium so your organization can manage projects, work, and resources more effectively across teams.
Learn More About Planner Premium
OnePlan
Integent can help you ensure continuity beyond Project Online by deploying OnePlan in the Microsoft Cloud—connecting portfolio governance, resources, and delivery execution for results.
Learn More About OnePlan
Microsoft Dynamics 365
Ensure business continuity with a custom cloud solution that connects your sales, service, finance, and operations teams to deliver measurable, predictable results.

Learn More About Dynamics 365
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Copilot Studio, the Microsoft Power Platform helps streamline and improve business functions.

Learn More About Power Platform
About Integent
Integent was founded in 2009 on the principles of building long-lasting relationships with customers, exceeding expectations, and providing outstanding customer service. 

We’re dedicated to providing a customized solution backed by our knowledgeable team of Microsoft experts.
Discover What Makes Us Different
News
Stay informed on Integent’s latest company updates and other important industry information. Our passion is customer success.
Read The Latest News
Videos
Learning new software doesn’t have to be difficult with our library of dozens of free training videos. Our video training always has something new.
Browse Our Training Video Library
Blog
Our industry experts share best practices and common pitfalls to avoid, in order to get the most out of your technology solutions.
Discover More

Search Results

March 24, 2017
Merging and Expanding Queries in Power Query

When using Power Query (Get & Transform) in Power BI and Excel, you have the ability to merge queries together and expand the dataset to view all the columns in your merged dataset. While you can do this in Power BI, the intrinsic join capabilities of that software program do not require you to perform […]

Read More
March 20, 2017
Improving Data Refresh with Power Query Options

I have been helping several customers recently with their reporting performance issues. The reports themselves performed well, but the data refresh took forever. There are two simple steps in Power Query for Power BI and Excel (Get and Transform in Excel 2016) that can drastically reduce your data refresh times. After making your connection to […]

Read More
December 11, 2015
Use Power Query to Shrink Odata Requests Down to Size

Most of the reports I create have a time element… Which client used the most project hours last year? ….. How many hours are my QA people scheduled to work next month?  Without that time framework, the information is less valuable. Time phased reports do, however, have an unfortunate side. The tables we must use […]

Read More
© Copyright 2026 | Integent.com | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram