Power BI – 12 Days of Dashboards

With the holiday carol “The 12 Days of Christmas” playing in my head, I’m excited to announce my upcoming “12 Days of Power BI Dashboards” blog series, where I will be sharing a new Power BI dashboard each day from December 12th – 23rd. The dashboards will be based on unique and yet common data…

4

Power BI & SSRS 2016 in an On-Premises Environment

Power BI and SQL Server Reporting Services 2016 in an entirely On-Premises Environment Jan. 17, 2017 – Another Update! The January release is a huge step toward realizing Power BI in an entirely On-Premises environment. In this technical preview, we see a few big improvements: Publishing Power BI reports directly to the SSRS Portal – With this glorious improvement,…

15

SSRS Report Manager issues when using SSL

SSRS Report Manager issues when using SSL – The Report Manager menu was not seeming to honor the SSL configuration settings After 28 straight blog entries about Power BI topics*, my customer work this week has led to 3 entries about SSRS. Interesting how that occasionally happens. I even squeezed in a case where MSDB had grown…

0

Connecting to SSRS through Management Studio throws “Invalid Namespace” Error

When connecting to a SQL Server Reporting Services instance through Management Studio, I encountered the following error: Report Server WMI Provider error: Invalid namespace (Microsoft.SqlServer.Management.UI.RSClient) It turns out that I was trying to connect to SSRS 2012 through SQL Server Management Studio 2014. Once I launched SSMS 2012, I was able to connect successfully, so…

2

SSRS Report Manager Configuration Wizard failed when Applying Connection Rights

The SQL Server 2012 SSRS Report Manager Configuration Wizard failed when Changing Database on step “Applying Connection Rights” Error Message: Cannot alter the role ‘RSExecRole’, because it does not exist or you do not have permission. Solution: The login used to connect to the database server did not have sufficient privileges on MSDB and Master….

0

Power BI Parameter Error – Invalid URI: The hostname could not be parsed

Today I encountered an issue in Power BI where a user was building a dashboard from a template I had created. The template has a single parameter, which is the full path to the exported .csv file. Several people have successfully used the template, but one user kept hitting the following error. DataFormat.Error: Invalid URI:…

3

Power BI 12 Days of Dashboards – Day 12 – Crazy Christmas Dashboard

Day #12 – Crazy Christmas Dashboard As part of my Power BI 12 Days of Dashboards series, day #12 brings this big project to a close with a Christmas Dashboard socked full of a few new tricks I learned throughout the creation of the blog series. In the customer environments that I support, I don’t…

4

Power BI 12 Days of Dashboards – Day 11 – NFL Football Touchdown Dashboard

Day #11 – NFL Football Touchdown Dashboard As part of my Power BI 12 Days of Dashboards series, I’m spending day #11 exploring NFL Football stats from www.pro-football-reference.com. As a huge sports fan, I love the data that Sports Reference provides and use it often for Power BI demos. The Power BI Dashboard uses the…

4

Power BI 12 Days of Dashboards – Day 10 – Exploring Twitter Data

I Day #10 – Exploring Twitter Data As part of my Power BI 12 Days of Dashboards series, day #10 explores Twitter data with four different interactive dashboards. I’ve had a Twitter account for a few years, but have only started to use it regularly over the past 6-8 months. I presented at a conference…

0

Power BI 12 Days of Dashboards – Day 9 – Building your first SCCM Report in Power BI

Day #9 – Building your first SCCM ConfigMgr Report in Power BI As part of my Power BI 12 Days of Dashboards series, day #9 will take a slight twist to the current format and help walk you through creating your first Power BI report leveraging data from System Center Configuration Manager (SCCM). I’ve also…

2

Power BI 12 Days of Dashboards – Day 8 – Fitbit Dashboard

Day #8 – Fitbit Activity Dashboard As part of my Power BI 12 Days of Dashboards series, day #8 showcases a customized Fitbit dashboard. This could easily be extended to build a dashboard for Garmin, Microsoft Band, or any other activity tracker that allows for data export. Here is an example of the dashboard showing…

9

Power BI 12 Days of Dashboards – Day 7 – Disk Usage Dashboard

Day #7 – Disk Usage Dashboard As part of my Power BI 12 Days of Dashboards series, day 7 brings you a new way to look at the old problem of disk space usage. I recently used Power BI in one of my enterprise customer environments to help visualize disk usage on the shared storage…

3