Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup174 2 Minute Tuesday: https://guyinacu.be/coalesce Patrick's tech video: https://guyinacu.be/pbidesktop Sources 7 TIPS FOR ENSURING SUCCESSFUL BUSINESS INTELLIGENCE ADOPTION (@BlueGraniteInc) Obtaining accurate totals in DAX (@marcorus) Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler (@cwebb_bi) Power BI Service [...]
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
Power BI buttons got a little more power! Navigation actions for Power BI buttons really streamline your reports and no longer require bookmarks. Power BI Desktop Samples: https://github.com/microsoft/powerbi-desktop-samples
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup172 2 Minute Tuesday: https://guyinacu.be/aggdefinebroke Patrick's tech video: https://guyinacu.be/hittingaggs Adam's tech video: https://guyinacu.be/gatewaycluster 📢 Become a member: https://guyinacu.be/membership Sources Monitor your On-premises data gateway with Azure and Power BI – Part 2 – Data source connectivity (@MarcLelijveld) From SQL to [...]
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.
Trouble defining your Power BI Aggregations? Field selection all grayed out? Patrick has a tip for you!
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup171 2 Minute Tuesday: https://guyinacu.be/controldrill Patrick's tech video: https://guyinacu.be/aggsconfigure 🔴 Live Stream Replay: https://guyinacu.be/paginatedlive 📢 Become a member: https://guyinacu.be/membership Sources Extending Power BI Buttons Beyond the Default Icons (@dataveld) Power BI – Reset Slicers with a Bookmark Button (@Laura_GB) Announcing [...]
Learn to configure your Power BI Aggregations table to really increase the speed of your DAX queries. This does NOT require Power BI Premium!