Power View in Excel 2013 and errors

Sometimes you get an error message that doesn't make any sense. "PC Load Letter" is quite a good example (Office Space, a great movie, shows how users react to such messages ūüėČ ). Here's an interesting one that I got when using Power View in Excel 2013 based on a tabular model: System.Reflection.TargetInvocationException: System.ComponentModel.Win32Exception (0x80004005):
Continue reading...

Reporting Services tip: document outline

If you are relatively new to Reporting Services, it can be difficult to keep track of all the report elements. Your report quickly gets cluttered with elements that are contained within each other. Not a lot of people seem to be aware that there is an option called 'Document outline', that makes it easy to
Continue reading...

Are you doing all the work?

Scenario 1: You're standing in front of the class. The training you're giving is going fantastic...it is your favorite subject and you can easily talk about this for hours on end. After the course your students fill in a survey about how well they like your course and the reactions aren't that great. What's going
Continue reading...

Package generation with SSIS - an overview

Although you can hardly ignore BIML (with bloggers like Cathrine Wilhelmsen and Bill Fellows sharing good stuff), there are still other options for package generation in SSIS. While enjoying a small conversation on LinkedIn about the automation options, I suddenly remembered still having a slidedeck from a presentation I gave early 2014. Please note that these are my
Continue reading...

Visual Studio Eror Messages

Yes, that typo was intended. Remember when I said this? [Using Google to find a solution to] Error messages? Be sure to include the exact message - "in quotes" Recently I encountered a occasion where this helped especially well. A colleague emailed me with the question why his VS2010 install didn't load his SSRS Preview correctly. The 'Run' functionality worked, but the
Continue reading...