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 […]