Posts filed under Intermediate

Extracting Multiple Tables From A Power Query Combine Folder Source

Video by: Reid Havens

One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.

Posted on December 4, 2018 and filed under Intermediate, Power BI, Power Query.

Power BI Feature Highlight: Many-to-Many Relationships

Video by: Reid Havens

In this video you'll learn about an exciting and recently announced feature for Power BI Desktop...MANY-TO-MANY Relationships. You'll see how easy it is now to connect two tables with non-distinct keys together using this new feature.

Posted on July 25, 2018 and filed under Intermediate, Power BI Features, Power BI.