Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, Fabric, enterprise Power BI, SQL Server BI, Data Modeling, SSAS Design, SSRS, Dashboards & Visualization since 2009
This first week of the new year has been a lot of housecleaning for me (literally and figuratively… my office…
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for…
Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros…
The best method to implement row-level security in a published Power BI model or SSAS Tabular model consumed from the Power BI service will depend to some degree on your data structure and requirements. The method I demonstrate here is one of the most flexible approaches and one that I commonly use in my projects.
If you are fortunate enough to be attending the Microsoft Data Insights Summit in Seattle along with about 2,000 others on June 12 & 13, I’ll look forward to seeing you there. This will be a great community event and a chance to meet, network and learn from well-known speakers, authors and product team leaders responsible for the best data analytics tools in the industry. The summit has been sold-out for a few weeks. If you can’t make it to Seattle to be there in person, you can still attend the conference! I don’t just mean that you can watch a few cherry-picked sessions and keynote addresses… You can watch every session for free. Selected sessions, which do include the keynote addresses, will be streamed lived during the conference but all of the sessions are recorded and will be available within two weeks after the last sessions wrap-up on June 13. This an awesome learning experience. I will post links and more details here about the recorded sessions after they become available.
If you are going to the summit, please attend my two sessions:
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports. Each of the posts is a condensed version of the material covered in a corresponding chapter from the book. Although I would love for you to buy the book to get the full edition of each topic, each post will contain valuable information that I hope will be informative and educational on it’s own; whether you buy the book or not. I’ll update this index with topics and links as I continue to add each post. Until then, some of these will serve as placeholders for future posts.
Please post comments or contact me through my blog if you have questions or feedback, or if you are interested in training and consulting related to this material. – Paul
Chapter 3 – Installation & Architecture…
This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical…
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. …
I recently needed to replicate all of the reports on one report server to a different server. I started downloading…
A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling…
Color coordination is important in report and dashboard design. We’ve seen theming and color pallet options in the prior iteration…
I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published…
Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from…
The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details for…
Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal…