fbpx

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

Are you HITTING your Power BI aggregations???

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.

Are you HITTING your Power BI aggregations???2020-03-18T07:20:50-05:00

Power BI Desktop update and more… (Roundup | March 16, 2020)

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

Power BI Desktop update and more… (Roundup | March 16, 2020)2020-03-16T07:32:49-05:00

Configure Power BI Aggregations

Learn to configure your Power BI Aggregations table to really increase the speed of your DAX queries. This does NOT require Power BI Premium!

Configure Power BI Aggregations2020-03-11T08:46:29-05:00
Go to Top