Power Query

PowerBI

When is a Date Not a Date in Power BI?

In this video, Patrick looks at how data types can be a tricky thing in Power BI. Be aware of what you are working with in order to avoid this problem in your charts.

Read More
PowerBI

3 ways to Reduce Data In Power BI Desktop

Sometimes you want to reduce data in Power BI Desktop so it’s easier to work with. Then work with all the data in the Power BI Service. Patrick from Guy in a Cube shows you 3 ways that can help do this without using Incremental Refresh or needing Power BI Premium.

Read More
Microsoft

How to easily automate boring Excel tasks with Power Query!

MyOnlineTrainingHub explains how  ower Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button. Get the files for this lesson here: https://www.myonlinetraininghub.com/introduction-to-power-query

Read More
Data

How Power Query Will Change the Way You Use Excel

Leila Gharani explains why PowerQuery is such a powerful tool. Excel Power Query has been a part of Excel since Excel 2016! It’s in the Data tab under Get and Transform. Unfortunately many people haven’t explored what it has to offer! They continue doing things the old “manual” way, Or the “complex” way with difficult […]

Read More