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