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

12 Power BI Dashboards, SSAS and SSRS Updates and Power BI AMA

Power BI – 12 Days of Dashboards (@SQLSamLester) New Combine Binaries Experience (@kpuls) What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services Power BI reports in SQL Server Reporting Services: Feedback on the Technical [...]

3 steps to pin Reporting Services visuals to a Power BI Dashboard

In this video, I show how you can configure Reporting Services to integrate with Power BI and then pin visualizations from a paginated report to a Power BI dashboard. There are three main steps you have to do to get this to work. Register with Power BI in Reporting Services Individual user sign in Pinning [...]