sqlsatkey

Upcoming SQL Saturday Precon Sessions (Update!!!!)

Wow, Power BI is making a tidal wave in the BI industry.  New features are being released regularly and blog posts are flying across twitter.  How can you keep up?  Well, if you are in Tampa, FL or Richmond, VA join me in one of these two full day sessions where I will explain and demonstrate how […]

SSRSandRLS

SQL Server 2016 Row-level Security and SSRS a perfect match

In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level Security (RLS) with SSRS.  Detailed steps including the TSQL script and SSRS project is provided at the end of this post.  To get started, you need to setup RLS.  In this example I will use […]

Power BI

From the Power BI dashboard to a specific page in a Report

Recently, I was working with a customer designing Power BI reports and dashboards.  Everything was going great until she asked this question, “Is it possible to set the hyperlink of a tile on a dashboard to go to a specific page on a report?”.  Hmmm, I thought.  Is it possible?  I dug around the Power […]

Excel

Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?

So two new exciting capabilities were announced recently in Power BI.  One involved Excel and the other SSRS, but they both involved pinning.  Microsoft announced the ability to pin certain visuals from SSRS to a Power BI dashboard and also the ability to pin a range from an Excel workbook to a dashboard.  A blog […]

sqlsat477_header

Atlanta BI Edition SQL Saturday Precon

The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy.  We are all trying to figure out, how do you keep up?  The Power BI team has released hundreds of updates since it with GA.  Then there is the upcoming release of SQL Server 2016.  […]

Power BI

Sentiment Analysis with Power BI

I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted to perform sentiment analysis and key phrase extraction. My first thought was to develop an Experiment using Azure Machine Learning (Azure ML). However, after doing a little research I stumbled upon a Text Analytics API […]