Another 30 Day Query Folding challenge!!!

Here is another 30-day Query Folding challenge video for you. Patrick takes on Day 7 and ramps up his Power Query knowledge! Will Power BI Desktop get the best of him??? GitHub Repot: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY

Another 30 Day Query Folding challenge!!!2022-05-18T09:20:00-05:00

Blown AWAY by Column From Examples in Power Query

Column From Examples, in Power Query, keeps blowing our mind! Patrick shows you an example where he wanted to extract some data. Will Column From Examples work? Of course, it will! Check this out! Add a column from examples in Power BI Desktop https://docs.microsoft.com/power-bi/create-reports/desktop-add-column-from-example

Blown AWAY by Column From Examples in Power Query2022-04-20T06:41:48-05:00

Can Patrick handle the challenge???

Can Patrick handle the challenge that Alex Powers presented to him? Can he actually complete the challenges of the Power Query 30-day Query Folding challenge? Let's find out... These are great for both Power BI and Microsoft Excel! 30 Day Challenge - Query Folding https://www.youtube.com/watch?v=9sV3hIn8VTY&list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Day 1 Challenge - https://www.youtube.com/watch?v=KZqZsCy5DaY&list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N&index=4 GitHub Repo: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY Query Folding [...]

Can Patrick handle the challenge???2022-03-23T08:53:10-05:00

So, we just wait???

What's up with the wait time in Power BI Dataflows? Do we just live with it? What's going on and what can we do about? Adam, has you covered! Understanding and optimizing dataflows refresh https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh

So, we just wait???2022-03-16T07:28:33-05:00

How we optimize Power Query and Power BI Dataflows

Let's go into Adam's mind as he optimizes Power Query to make some Power BI Dataflows run faster to avoid resource usage. The result is INSANE AMAZING! Power Query M function reference https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

How we optimize Power Query and Power BI Dataflows2022-01-20T07:30:37-05:00

To Pivot or Unpivot? That is the question!

Sometimes your data isn't shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports! Pivot columns https://docs.microsoft.com/en-us/power-query/pivot-columns Unpivot columns https://docs.microsoft.com/en-us/power-query/unpivot-column

To Pivot or Unpivot? That is the question!2022-08-19T07:01:37-05:00

What are Power BI data connectors and why should you care?

You need a connector to work with data in Power Query for Power BI or Excel. But what is a connector? Adam explains what these are and how to find out what's available. Power Query Connectors: https://docs.microsoft.com/power-query/connectors/ Power BI data sources: https://docs.microsoft.com/power-bi/connect-data/power-bi-data-sources Import vs DirectQuery vs Live video: https://www.youtube.com/watch?v=-ip7mKUdwRg Power Query Custom Connectors: https://docs.microsoft.com/power-query/startingtodevelopcustomconnectors CDATA [...]

What are Power BI data connectors and why should you care?2022-08-19T07:01:40-05:00

Power Query! Uggg – Where do you start? | Power BI

Not a coder? Don't understand Power Query M syntax? Power Query can be fun, but can also turn complicated. Learning Power Query can make Power BI and Excel very rewarding. Adam has some resources to get you started in your journey. Concept: Roche's Maxim https://ssbipolar.com/2021/05/31/roches-maxim/ Beginning the journey: Power BI Learn (Free) https://docs.microsoft.com/learn/powerplatform/power-bi Course: Power [...]

Power Query! Uggg – Where do you start? | Power BI2021-09-30T07:54:44-05:00

When is a date not a date in Power BI?

When is a date not a date? We all use them in our data. 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.

When is a date not a date in Power BI?2021-09-08T06:12:22-05:00
Go to Top