fbpx

Bring Power BI and Excel together

STOP defaulting to exporting your Power BI data to Excel! Adam shows you options you can use within Power BI to still work with your data in Excel if that's what you are comfortable with.

Bring Power BI and Excel together2022-11-03T06:12:56-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

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

How do I get my Excel users to use Power BI???

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

How do I get my Excel users to use Power BI???2022-02-09T07:03:54-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

Do I need to be an expert in Power Query M?

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!

Do I need to be an expert in Power Query M?2021-01-20T07:01:42-05:00

Power BI in Excel updates and more… (Roundup | Aug 31, 2020)

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 [...]

Power BI in Excel updates and more… (Roundup | Aug 31, 2020)2020-08-31T08:15:09-05:00
Go to Top