Power BI

How to get Power BI RLS to work with external users

Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this post. Power BI has made sharing dashboards and reports inside and outside of an organization relatively simple. All you really need is an email address. Now, whether or not the person will be able to […]

PBIKPI

What’s wrong with the Power BI KPI Visual?

Over the past couple of weeks I have been asked several times about the KPI Visual that is native to Power BI.  Each time the same, “it does not appear to work properly.”  Well, I wasn’t sure what all the confusion about.  So, I decided to spend some time working with the visual. To start, […]

Power BI

Higher Education Retention Analytics using Power BI

Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This solution shows student persistence, retention, and graduation patterns, leveraging a Student Information System (SIS) as the data source. Year-over-over retention and graduation rates can be filtered to allow deeper examination of trends at the college […]

image_thumb.png

Refreshing KPI Data in SSRS 2016

Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to configure scheduled data refresh for the KPI that was created in that blog post. Prerequisites 1.  SQL Server Agent must be running 2  Credentials must be stored in the Data Source 3. Caching must be […]

sqlsatkey

More SQL Saturday Precon News(Real-time Dashboards)!!!!

As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA.  Well, I just found out that I will be delivering the same session in Houston, TX at their SQL Saturday.  Bring your laptop, grab a cup of coffee and get ready to learn.  You can […]

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

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