Catching up on Power BI updates (Tooltips, Hololens and more)

Power BI Service and Mobile February Feature Summary Announcing Persistent Filters in the Power BI Service Share your Power BI content with anyone by email Power BI Desktop March Feature Summary Power BI for Mixed Reality app now available in Preview BONUS ITEMS: BI Bake Off at Gartner Data and Analytics Summit 2018 On-premises data [...]

Mark as Date Table in Power BI Desktop is here!

Mark as Date Table in Power BI Desktop is finally here! In this video, Patrick takes what Adam did with a custom date table and shows you how you can use Mark as Date Table in Power BI Desktop. This feature was introduced in the February 2018 release of Power BI Desktop. Mark as Date [...]

Power BI date table: create using DAX

In this video, Adam looks at how to create a Power BI date table using DAX. The end result uses a combination of the GENERATE(), ROW() and CALENDARAUTO() DAX functions to create a calculated table resulting in a Power BI date table. Using GENERATE and ROW instead of ADDCOLUMNS in DAX

Coming to Europe! SQLBits and SQL Konferenz

Patrick and I will be coming to Europe at the end of February! We would love to meet you and have some awesome conversations around Power BI, or anything really. We will be at SQL Bits from February 21st thru the 24th and will be delivering two full-day pre-conference sessions. One on Power BI embedding [...]

Power BI Desktop updates, Certificate prep, DAX and more…

Power BI Quiz (Test Prep for Certification) (@rsaprano) The definitive guide to ALLSELECTED (@FerrariAlberto) Share reports with your teams and partners Connect to tens of thousands of datasets on with the new connector for Power BI Desktop Power BI Desktop February Feature Summary BONUS ITEMS: Joining tables In Power BI using Power Query and/or [...]

Create a Power BI app registration in 6 steps

We look at a Power BI tutorial on how to properly complete the app registration within Azure Active Directory (AAD). This power bi tutorial is needed as we see many questions about the proper configuration for a Power BI app registration regarding which settings to use. App registrations are needed to use the Power BI [...]

Use a KPI in a table within Power BI

In this video, Adam shows you how you can import KPIs from Excel into Power BI. Once in Power BI, you can use the KPI in a table or matrix. Documentation: Import and display KPIs in Power BI

Power BI, Azure Analysis Services, and the gateway data region

In this video, Adam looks at data regions and how they work with Power BI, Azure Analysis Services, and the On-Premises Data Gateway. For the use of a single gateway, all services must be within the same data region. Using a second gateway might be your only option to get things to work.

Using Azure SQL Database Failover with Power BI

In this video, Patrick shows you how you can easily use Azure SQL Database Failover Groups with Power BI to ensure you have access to your data. Connecting to an Azure SQL Database Failover Group from Power BI is easier than connecting to a secondary replica of an Always On Availability Group.

Power BI User lookup with the gateway using Active Directory

In this video, Adam looks at how you can use Active Directory custom attributes for the user lookup with the Power BI Gateway. This can be used for both Analysis Services mapping and the Kerberos SSO with DirectQuery connections. Manage your data source - Analysis Services Creating Custom Active Directory Attributes Adding Custom Attributes in [...]