In this video, we look at a simple example of how Power Query can supercharge your reporting abilities for values brought into excel via the data connector.

I’ve found Power Query to be a great tool for efficiently combining data that lives across two different D365 data entities. It is a fantastic tool for data migration or analysis in general.

Some Concepts:

• Pivot Tables
• Refreshing Data
• Connecting Data to Power Query
• Merging Two Data Sources in Power Query
• D365 Relationship Between Projects, Project Contracts, and Sales Currency