Power BI Paginated reports: using String_Split to improve multi-value parameters
Patrick looks at how you can use the STRING_SPLIT SQL Function to make life easier when using multi-valued parameters within Power BI Paginated reports.
SSRS APIs, M Queries, Power BI Desktop and more
Exploring The New SSRS 2017 API In Power BI (@technitrain) Bulk-extracting Power Query M-code from multiple pbix files in Power BI (@TheBIccountant) Automatic installs of Power BI Desktop (@CurbalEN) How administrators can manage the Power BI Desktop sign-in form Visualizing and interacting with your Azure Machine Learning Studio experiments Congratulations to the Winners of the [...]
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 [...]