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

smallpx-Microsoft_SQL_Server_Logo_svg

Using Power BI to list Enterprise Only SQL Features

Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the web.  I pointed them to the Features Supported by the Editions of SQL Server web page and thought I was done.  He stated that this site was good, but did not provide a simple list […]

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

sqlsatkey

SQL Saturday 486: Richmond, VA Precon

Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend SQL Saturday #486.  The session will be held on Friday March 18.  If you haven’t registered, there are still seats available. If you want to learn how to build a Power BI solution for your organization […]

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