fbpx

Let Power Query write your SQL for you!

We tell you to push your transformations upstream as much as possible. But you don't know how to write SQL. That's ok, let Power Query do it for you to move your project forward. Patrick shows you how!

Let Power Query write your SQL for you!2022-10-10T03:54:23-05:00

A Power Query feature you may not know about!

We thought everyone knew about this Power Query capability! At the Power Platform Conference, we found that many did not. Well, we want to help make sure everyone is aware so that you can reuse your awesome Power Query work in Power BI or Excel!

A Power Query feature you may not know about!2022-10-06T07:53:53-05:00

Do you need Functions in Power Query?

You can do amazing things in Power Query! Maybe you think to create a function. But do you really need a function for that? Or is it over complicating things?

Do you need Functions in Power Query?2022-09-28T06:14:47-05:00

Refresh and NO DATA in my Power BI visuals???

Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you. Troubleshooting refresh scenarios https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios Data types in Power BI Desktop https://docs.microsoft.com/power-bi/connect-data/desktop-data-types Damu Venkatesan: https://twitter.com/vdamu https://www.linkedin.com/in/damuvenkatesan/

Refresh and NO DATA in my Power BI visuals???2022-08-17T06:30:35-05:00

You thought DAX? Alex shows you Dynamic M-M-Magic!

We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you! Connect with Alex: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ Power Query folding https://docs.microsoft.com/power-query/power-query-folding 30 Day Challenge: Query Folding https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Power Query [...]

You thought DAX? Alex shows you Dynamic M-M-Magic!2022-08-10T05:51:34-05:00

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
Go to Top