Tech Videos2019-08-01T07:39:27-05:00

Wednesday/Thursday – Power BI Technology and More

Every Wednesday & Thursday, we look at a tech topic. This could be a new feature, how something works or how to troubleshoot something within Power BI technology, Reporting Services and Analysis Services.

This may also include the occasional topic relating to the Microsoft Data Platform as a whole, such as SQL Server or an Azure technology. Because of Power BI, there will also be content related to Office 365 and Azure Active Directory.

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

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

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

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!