Is Power BI intimidating? Coming from Microsoft Excel? You consider yourself non-technical? Don't want to have to write or know anything about DAX? Patrick looks at how you can create a report quickly with just your Excel data and not have to write any code!
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 141 blog entries.
Have you really used the Power BI model view? Patrick walks through some of things he loves about it. Both some old favorites and some newer items you may not be aware of.
We've seen people comment that Power BI is SLOW. But, what they really mean is your report is slow. Patrick breaks things down to get you pointed in the right direction. Chris Hamill's Blog: https://alluringbi.com/2020/08/06/consolidating-report-elements-for-improved-performance/
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!
Are you using Microsoft Forms to capture information and want to pull that into Power BI? Also to be able to refresh that data? Patrick has you covered and gives you some pointers.
We know that DAX, in Power BI, can be intimidating. We've been there. Patrick shows you how you can learn DAX using what you have available today and TAME the beast that is DAX! DAX.Guide: https://dax.guide DAX Studio: https://daxstudio.org/ DAX Patterns: https://daxpatterns.com Microsoft Learn: https://docs.microsoft.com/learn/paths/dax-power-bi/ Download Sample
Maybe you want your Power BI report users to get be notified of some changes that occurred. And, you want that displayed within the report. Patrick has a way you can do just that!
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!
Are you using a flat table in your Power BI report? You may be missing out! Patrick explores what a STAR SCHEMA is and why you should be using it. Guidance doc: https://docs.microsoft.com/power-bi/guidance/star-schema DAX.tips: https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
Do you work on your Power BI dataset or data model? Are you following best practices? Patrick walks you through a best practice analyzer set for Tabular Editor, from Michael Kolvasky, that can help you improve your data model. Blog post: https://powerbi.microsoft.com/blog/best-practice-rules-to-improve-your-models-performance/ Tabular Editor: https://tabulareditor.com/ Download BPA Rules: https://github.com/microsoft/Analysis-Services/tree/master/BestPracticeRules Michael Kolvasky's Blog: https://www.elegantbi.com/ Feedback: firstname.lastname@example.org