fbpx

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 accurate totals in DAX (@marcorus) Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler (@cwebb_bi) Power BI Service [...]

Power BI tips & updates and a COVID-19 USA report (Roundup | April 6, 2020)2020-04-06T09:10:24-05:00

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

Getting Started with Power BI Desktop in 5 steps2020-04-01T07:52:38-05:00

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

Setting default values using COALESCE in DAX2020-03-31T07:50:26-05:00

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 Single Sign-on with the Power BI Gateway2020-03-26T08:31:23-05:00

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

Using Precedence to force Power BI Aggregations2020-03-25T08:37:33-05:00

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

Make navigation easier with Power BI buttons2020-03-24T07:15:55-05:00

Power BI updates, tips and Coronavirus… (Roundup | March 23, 2020)

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

Power BI updates, tips and Coronavirus… (Roundup | March 23, 2020)2020-03-23T07:57:51-05:00

What the HECK is a Power BI Gateway Cluster?

Confused about what a Power BI Gateway cluster is? Have your On-Premises Data Gateway installed but it's overloaded? This video is for you! Documentation: https://docs.microsoft.com/data-integration/gateway/service-gateway-high-availability-clusters PowerShell: https://docs.microsoft.com/data-integration/gateway/service-gateway-powershell-support Download Cube Sheet

What the HECK is a Power BI Gateway Cluster?2020-03-19T07:48:35-05:00