fbpx

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

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

Intro to R with Power BI

You enjoyed the intro to Python video, now let's look at R Script within Power BI! There are a lot of similar aspects and Patrick walks you though what you should know to get started. Documentation: https://docs.microsoft.com/power-bi/connect-data/service-r-packages-support https://blog.rsquaredacademy.com/data-visualization-with-r-box-plots/

Intro to R with Power BI2021-07-21T05:38:40-05:00

Create Buckets or Groups with Power Query in Power BI

There are different ways you can create buckets or groups for your data in Power BI. Patrick shows you how this can be done with Power Query along with a few other options.

Create Buckets or Groups with Power Query in Power BI2021-07-08T05:26:58-05:00
Go to Top