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
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 [...]
Lots of people use Excel and love it! But what about Power BI? Why not use both together? Patrick looks at how Excel users can take advantage of Power BI and may just start using that! Start in Excel to connect to Power BI datasets https://docs.microsoft.com/power-bi/collaborate-share/service-connect-excel-power-bi-datasets
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 [...]
If you need to change your data source references in Power Query, you are probably doing them individually. We found an INSANE AMAZING tip to make you way more efficient and it works in Power BI and Excel!
Maybe you've heard of Power Query M in Microsoft Excel, Power BI or something else. Do you really need to be an expert in that? Or even use it? Patrick helps to ease your mind!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup191 Patrick's tech video: https://guyinacu.be/dynamictitle Adam's tech video: https://guyinacu.be/onecheckbox 🔴 Live Replay: https://guyinacu.be/live023 📢 Become a member: https://guyinacu.be/membership Sources #POWERBI BUTTONS WITH ANIMATION (@pkamasani) Power BI - Visual Pagination (@PowerBIElite) Distinct Count in Power BI (@Rad_Reza & @PhilSeamark) Simplifying enterprise [...]
DAX Studio is an awesome tool! You can even use it to trace Power Pivot within Excel. Patrick shows you how!
Take your Power Pivot model in Excel and easily convert it to Power BI in just a few steps. Patrick looks at a few different ways to do this.
Showing off 3 HIDDEN tricks in the Power Query editor, in Power BI and Excel, that you may not have known about. Little things that take Power Query to the NEXT LEVEL!