Skip to content

How To Use Query Parameters In PowerBI Flat File Data Sources

How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.

Read more

Connecting R Scripts to SQL Azure for Data Discovery and Profiling

I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations.  R provides many packages and functions that let you perform data discovery over a data set.

Read more

Year-In-Photos Challenge Changed my Work-Life Balance Outlook

I took the Instagram year-in-photos challenge almost two years ago, and it has provided me with many rewards and drastically changed how I look at my day.

Read more

Create HTML Documentation for Your Data Discovery

There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.

Read more

Make Your Job Great Again

When you have a string of projects that fail to push your boundaries and fire up your passions. Here are 5 actions to reignite that spark and create new opportunities.

Read more

A Consultant’s Guide to Work Life Balance​

This article will impart what I have learned over my 20-year consulting career and provide some strategies to help you find your balance. I am writing this article from a consultant's point of view, but we all struggle with these priorities and expectations as an employee or entrepreneur. Also included is a simple methodology to help measure your work life balance and assist in determining where your time is going.

Read more

Getting the Latest Azure Storage Explorer Version

I was working with a client the other day who was using the Microsoft Azure Storage Explore. They were trying to create a folder in an Azure blob storage location and could not find the option to do it. We seemed to be talking about 2 different products. Funny enough we were.

When you do a search for Microsoft Azure Storage Explore, the CodePlex version still ranks very high on the search results even though it has not been updated since August 2014. People get tripped up if they remember the CodePlex version.

The Latest version is currently updated and is available on Windows, Mac and Linux. If you are using the free Azure Storage explorer, use this one.

AzureFileExplorerNew

PowerBI June Update & Table Export Issue

Update:  This issue has been corrected with the August 2017 update release.

One of the must-have features I have been desperate to see in PowerBI is the ability to have word wrap in tables. The June 2017 Update, released on July 3, has updated Table and Matrix visualizations which include a number of new features. A detailed list of features are listed on the PowerBI documentation site, PowerBI Desktop Matrix Visual.

With these features being released, I had a client send me an email concerning an issue they were facing.

As you see pictured below, the 3 dots of “More” options now has “Sort By” functionality for each column in the table. My client created a table that has more columns than can be shown on the fly out. This pushes the export data to the bottom without the ability to scroll to get to the export data option.

Export Data

I have looked into it and cannot, at this point, find a way to get to the export data option when there are many columns in the table. I told them to use the older version of the table from the May 2017 PowerBI Desktop version. For the time being, this has them fine and is the only workaround I have found.

I am certain this will be fixed, however, if you have a large table and use the export data feature, beware.

Steve

Reintroduction

My name is Steve Young and for the last 10 years, I have been a consultant with Microsoft specializing in business intelligence, data visualization, and the SQL data platform. 

Read more

Great Time Graph Tells the Story

I must say that this is the most amazing visual I have seen in a while. The animation over time shows exactly what the author intended in a very simple and visual way. The colors are not jarring and change with the intensity of the data. The bar chart at the bottom is a little hidden, but perfectly placed not to take away from the main story the author is trying to portray.

I found that this was a perfect visualization example for the trend over time of the temperature data.

https://www.bloomberg.com/graphics/hottest-year-on-record/

 

%d bloggers like this: