Todd Shilhanek's Articles

Todd Shilhanek's avatar

posted by
548 views

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 i ...


Todd Shilhanek's avatar

posted by
322 views

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 Exce ...