Power BI tips & updates and a COVID-19 USA report (Roundup | April 6, 2020)

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 [...]

Getting Started with Power BI Desktop in 5 steps

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. [...]

Setting default values using COALESCE in DAX

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

Using Single Sign-on with the Power BI Gateway

Let's dig into the Power BI gateway and Single Sign-On (SSO) using Kerberos! This can be used for both DirectQuery and refreshing a Power BI dataset. Documentation: https://docs.microsoft.com/power-bi/service-gateway-sso-overview Download Cube Sheet  

Using Precedence to force Power BI Aggregations

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

Make navigation easier with Power BI buttons

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