With the October release of Power BI Desktop, users have the ability to leverage 2 really cool features: Bookmarks and the Selection Pane. With bookmarks, you can create a custom/modified view of your report and save a version of that state, allowing you to go back to that view either through a PowerPoint-like presentation, or […]
Author: Victor Rocca
PASS Summit Recap – Days 1-3
This post is a continuation of my last post, PASS Summit 2017 Recap – PreCon Sessions and focuses on days 1-3 of the conference. The next few days at PASS Summit were jam-packed with sessions, key-note speakers, vendors, and networking events. I tried picking the sessions that would give me the most benefit by attending in […]
PASS Summit 2017 Recap – PreCon Sessions
This last week I had the opportunity to attend my first PASS Summit in Seattle, and it was an awesome experience! I got to meet lots of great people, ran into some old colleagues, and learned about the latest tools and technologies. I’ll summarize my first 2 days at the conference in this post and […]
Houston Home Appraisal Values with Power BI
Here’s an updated version of the 2016 Houston home appraisal values Power BI report. I included a Trends tab that makes use of Power BI’s forecast feature to project the Average Appraisal Value and YOY Appraisal Change for the years 2017-2020. It’s interesting to note that while homes continue to appreciate in value, the amount […]
Using Color Gradients to Improve Your Visuals
I recently came across a requirement to report the number of devices owned by customers, along with the age of each of the devices (how long it had been in service). The idea behind it was to be able to quickly see customers that had the majority of their devices within the replacement window (10+ […]
Displaying a Power BI Dashboard in Your Office
cLast week I did some research on how to render a Power BI report on a TV for the purposes of displaying it in an office. A good case scenario for this is if you have a help desk or service desk team and you want to show how each person on the team is performing and how they […]
Comparing Power BI and SSRS Mobile Report Publisher
Power BI and SQL Server Mobile Report Publisher (previously known as Datazen) are both Microsoft BI tools that offer mobile reporting capabilities. Mobile Report Publisher is part of the SQL Server 2016 release and provides on-premise mobile reporting functionality to SQL Server Reporting Services. Power BI is a standalone cloud-based service that provides similar mobile reporting […]
Migrating SSRS Mobile Reports Across Servers
SQL Server Mobile Report Publisher does not have an intuitive way for moving a mobile report across servers, and I wasn’t able to find any documentation about this online. So how do you go about doing this? I came across a couple of options while testing different approaches, which are described below. If you have found a […]
How to Replace a Data Source Connection With a Live Connection in Power BI
I recently ran into a scenario where I developed a Power BI report against a SQL database using a live connection, and later developed a Tabular cube that I wanted to use to replace the SQL data source. As it turns out, replacing one live data source with another is not as straightforward as it […]
Power BI – Tips & Tricks Part II
Below are some new (maybe old for some of you!) tips & hints that will come in handy when building new Power BI reports: Use the Shift + Arrow Keys to Move Items in Bigger Increments If you’re trying to get the location of a visual just right, and need to use the arrow keys instead […]