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.
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 108 blog entries.
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!
Sometimes you end up with a LOT of measures that are related. You can reduce the number of measures with Calculation Groups in Power BI and clean up your field list! Download Sample
Learn how you can take conditional drill to the NEXT LEVEL in Power BI Desktop with buttons. Patrick also shows how you can add in dynamic page navigation as well. Download Sample
There is a NEW way to create measures in Power BI with the July 2020 Power BI Desktop update. Patrick shows you how External Tools can help you.
Everyone tells you that you need a date table for time intelligence in Power BI. Not so fast! Patrick shows you how you can use quick measures, like year over year, with a quick measure and no date table! Download Sample
How do you use integer date keys with Incremental Refresh in Power BI??? Patrick walks you through how to do it. Documentation: https://docs.microsoft.com/power-bi/admin/service-premium-incremental-refresh Download Sample
Not sure what Row-Level Security (RLS) is in Power BI? Patrick gives you a quick look at what it's about and how to use it. Documentation: https://docs.microsoft.com/power-bi/admin/service-admin-rls 🎓 Continue your journey with our Row-Level Security course: https://guyinacu.be/rlscourse
We reduced a Power BI dataset size by 83% by doing one simple thing. It's time to get serious about your data model! Download Sample
Tired of having a ton of buttons to accommodate page navigation within your Power BI report? Conditional navigation is an INSANE AMAZING way to reduce visuals on the report and provide a clean way to navigate your report. Download Sample