Did you know you could copy queries, in Power Query, between Power BI or Excel files? Even Notepad? Patrick shows you how, and more...
About pleblancThis author has not yet filled in any details.
So far pleblanc has created 102 blog entries.
Stop refreshing one table at a time! Also, don't wait for the entire data model to finish refreshing. Refresh multiple tables within Power BI Desktop. Gilbert Q's Blog: https://www.fourmoo.com/2020/04/22/how-to-refresh-selected-not-all-tables-in-power-bi-desktop/
The model view, in Power BI Desktop, is really powerful. Patrick shares 3 tips that you may not have known about.
Power BI Paginated Reports in a Day training is available for you to go through. You don't need Power BI Premium to go through the training either! Get it here: https://docs.microsoft.com/power-bi/paginated-reports/paginated-reports-online-course
Power BI has a lot of options you can set. Here are Patrick's 3 favorite options in Power BI Desktop!
Learn to easily create a hierarchy in Power BI. This seems to be a new way that snuck into Power BI Desktop!
Getting started with Power BI Desktop is easy! Patrick looks at 5 steps to get you up and running quickly with Power BI Desktop. From downloading, to getting data, and then building your report visuals. Getting started with Power BI Desktop https://docs.microsoft.com/power-bi/desktop-getting-started https://docs.microsoft.com/power-bi/guided-learning/gettingdata#step-2 Introduction to modeling your data https://docs.microsoft.com/en-us/power-bi/guided-learning/modeling#step-1
Learn how to get default values using the DAX COALESCE function instead of IF statements. A great way to avoid BLANK in Power BI! Documentation: https://docs.microsoft.com/dax/coalesce-function-dax SQLBI.com article: https://sql.bi/659297
Are your Power BI Aggregations not matching? Setting Precedence can control which Power BI aggregation will be preferred. A little hint to help it on its way! Documentation: https://docs.microsoft.com/power-bi/desktop-aggregations#aggregation-precedence
Are you not sure if you are hitting your Power BI Aggregations? Patrick shows you some tools you can use to verify if they are being used.