Free book, Updates for SSRS and SSAS and an updated Power BI gateway

Online Book: Analytics with Power BI and R (@leila_etaati) When to Use SUM() vs SUMX() (@ExceleratorBI) Model Comparison and Merging for Analysis Services SQL Server 2017 Reporting Services Release Candidate now available Power BI On-premises data gateway – July Update is now available! BONUS ITEMS: Value.Compare in Power BI, An Advanced Power BI Class Excerpt [...]

Adam and Patrick Unplugged – May 2017 [EP3]

In this episode of the Adam and Patrick Unplugged Show, we were at SQL Saturday NYC and thought we would bring in a few guests to join us and talk about what they are doing and what they could share with you! Jonathan Stewart (1:31) Twitter: @SQLLocks Website: https://sqllocks.com Where you can see Jonathan next: [...]

Power BI Premium, Apps and Report Server

So many announcements for Power BI this week! Also, it is Star Wars day!!! May the 4th be with you! Power BI Desktop May Feature Summary Microsoft accelerates modern BI adoption with Power BI Premium Power BI Premium Calculator Power BI initial SKU and pricing information Power BI Premium webinar (May 11th) Distribute to large [...]

Adam & Patrick Unplugged – April 2017 [EP2]

In this video, Patrick and I talk about what is on our minds. We take a look at some updates in Analysis Services 2017 CTP 2.0. We look at the new navigation experience in Power BI that is coming out in early May. We also talk about some friends, Santa Clause and Power BI reports [...]

Drill from a mobile report to a paginated report in SSRS (SSAS)

In the first post in this series, I explained how to drill from a mobile report to a paginated report that contained parameters populated from a SQL Server database query. This was pretty simple and straightforward. What if the data in the parameter of the paginated report was populated from a SQL Server Analysis Services [...]

Drill from a mobile report to a paginated report in SSRS (SQL Server)

The release of SQL Server 2016 included many new and innovative features. One that intrigued me the most was the integration of Mobile Reports into SQL Server Reporting Services (SSRS). Recently, I was planning a full-day hackathon focused on the Microsoft Data Platform and I was asked to show drill from an SSRS Mobile report [...]

Connect from Power BI Mobile to SSRS using OAuth

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

Configure Kerberos for Power BI reports in Reporting Services

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

DAX, Power BI in SSRS and more…

DAX Time Intelligence for Beginners (@ExceleratorBI) Defining the Components of a Modern Data Warehouse (@sqlchick) Publish Power BI Reports to SSRS On-premise Preview Now Available (@Paul_Turley) Help Improve DirectQuery! Introducing email subscriptions in Power BI: stay informed when it matters BONUS: Compare equivalent periods in DAX (@marcorus) Seven Steps for Using Data and Power BI [...]