fbpx

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

Intro to Python in Power BI

Using Python and curious how to use it with Power BI? Patrick explores how you can do just that! Python + Power BI can be a powerful combination. Power BI Python documentation: https://docs.microsoft.com/power-bi/connect-data/service-python-packages-support Seaborn Tutorials: https://seaborn.pydata.org/tutorial.html

Intro to Python in Power BI2021-06-22T04:23:58-05:00

Enable QUERY FOLDING for native queries in Power Query / Power BI

We have usually said that if you use a native query, you break query folding in Power Query. Interesting. There may be a way to enable it in Power BI! Patrick shows you how. Chris Webb Blog: https://blog.crossjoin.co.uk/2021/02/21/query-folding-on-sql-queries-in-power-query-using-value-nativequery-and-enablefoldingtrue/ Query folding guidance in Power BI Desktop https://docs.microsoft.com/power-bi/guidance/power-query-folding Visualise your Power BI Refresh https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/

Enable QUERY FOLDING for native queries in Power Query / Power BI2021-05-06T04:43:14-05:00

Best kept SECRET in Power BI??? You tell us!

Have we found the best kept SECRET in Power BI? Adam saw this recently and was BLOWN away! Zooming in can help with presenting in business settings and anywhere else. Here are a few things you can use to make that presentation better with Power BI. ZoomIt: https://docs.microsoft.com/sysinternals/downloads/zoomit DAX Studio: https://daxstudio.org/

Best kept SECRET in Power BI??? You tell us!2021-04-22T06:26:45-05:00

3 ways to REDUCE DATA In Power BI Desktop (No Premium needed!)

Sometimes you want to reduce data in Power BI Desktop so it's easier to work with. Then work with all the data in the Power BI Service. Patrick shows you 3 ways that can help do this without using Incremental Refresh or needing Power BI Premium!

3 ways to REDUCE DATA In Power BI Desktop (No Premium needed!)2021-03-24T07:25:55-05:00

Create your first Power BI report

New to Power BI? Adam helps you get started with creating your first Power BI report in Power BI Desktop! Start your journey the right way! Guy in a Cube Blueprint Course: https://guyinacu.be/pbiblueprint Star Schema: https://docs.microsoft.com/power-bi/guidance/star-schema Star Schema Book: https://amzn.to/38JQJqq Definitive Guide to DAX: https://amzn.to/2MTIi3h Power BI Blog: https://blog.powerbi.com Power BI documentation: https://docs.microsoft.com/power-bi Power BI [...]

Create your first Power BI report2021-01-21T08:17:27-05:00
Go to Top