In this video, I open up the Loot Crate box for February 2017 with the theme of build. It included a Power Rangers T-Shirt, a lego batman food container, some Tetris magnets and a lego dimensions character.
In this video, I show you how to configure Active Directory Federated Services (ADFS) and the Web Application Proxy (WAP) role, in Windows 2016, so that you can connect from Power BI mobile to SQL Server Reporting Services using OAuth. The ADFS and WAP servers need to be running Windows Server 2016 in order for [...]
Use Power Query to Compare Database Records (@ExceleratorBI) Finding Out Which MDX Calculations Are Being Evaluated By Your Query In Analysis Services Multidimensional (@technitrain) Power BI Service January Feature Summary Now in preview: Conversational BI with Q&A on Power BI mobile apps (iOS) Power BI Desktop February Feature Summary BONUS: Using SUMMARIZECOLUMNS instead of SUMMARIZE [...]
In this video, I look at the new Dual KPI custom visual for Power BI. The Dual KPI efficiently visualizes two measures over time. It shows their trend based on a joint timeline, while absolute values may use different scales, for example Profit and Market share or Sales and Profit. Each KPI can be visualized [...]
I walk through how to configure Kerberos to get Power BI reports within SQL Server Reporting Services running in a distributed environment. This means Analysis Services is not on the same machine as Reporting Services. I start by showing how to configure the data source with a stored credential and using EffectiveUserName. This is similar [...]