Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

21 March
2015
Author: TyroneBrown

Depreciation Pattern for SSAS Tabular and Power Pivot Data Models

This post is to describe a pattern to measure the depreciation of an expense using DAX in a SSAS Tabular or Power Pivot data model. The pattern accounts for a variable length of depreciation, called here a Depreciation Schedule. The pattern will account for a depreciation expense for an equal...
06 August
2014
Author: TyroneBrown

Visual Studio 2012 Error when executing SSIS package in SSDT 2012:

Earlier today I came up when executing a SSIS package on a workstation that recently had SQL Server Data Tools for Visual studio 2012 installed. It says, “Method not found:...
06 July
2014
Author: TyroneBrown

Power Query Error: We couldn’t refresh the table… Out of line object … has been specified but not used.

    Earlier this week I encountered a new Power Query error when I attempted to update a Power Query that I had previously created to load a Power Pivot model. Unfortunately, when queries are changed after a Power Pivot model is created, the underlying metadata does not...
16 March
2014
Author: TyroneBrown

SSIS 2012 T-SQL Package Execution with Dynamic Environment Parameter

SQL Server 2012 provides the useful feature of SSIS package execution via T-SQL commands. One issue, I’ve encountered is the need to retrieve a deployed SSIS project’s configured environment, and pass the environment’s reference ID into the T-SQL script executing the SSIS...
14 March
2014
Author: TyroneBrown

The Best SharePoint PowerPivot Data Refresh Troubleshooting Resource I Can Find

Here’s the best resource I could find for troubleshooting PowerPivot Data Refresh in SharePoint.

Troubleshooting PowerPivot Data Refresh

If you have any other great resources, please share them in the comments section.

07 March
2014
Author: TyroneBrown

TFS Error: Value was either too large or too small for a UInt32

Value was either too large or too small for a UInt32 I recently encountered this error when trying to check in some changes into TFS. The error isn’t very helpful. The problem was that one or more files needed to be saved, and MS Data Tools didn’t prompt for saving prior to...
27 January
2014
Author: TyroneBrown

Filter Dropdown SSRS Parameters with a Comma-Delimited List Search Box

I recently encountered an interesting problem when working with a client.  I made an SSRS report that used a multi-select drop down box parameter that used a textbox to search and filter the items in the dropdown parameter.  The query for the drop down list was pretty...
19 November
2013
Author: TyroneBrown

Webinar: Controlling Your SSIS Control Flow Using Containers

The Control Flow of SSIS provides numerous ways to control the processing of your ETL tasks. Fortunately, programming is no longer required to control looping and processing logic as they were in DTS due to the introduction of SSIS containers. In this beginner-level session we’ll learn how...
03 November
2013
Author: TyroneBrown

Resources for New SQL Server Developers

About every month or so a new group of students tour the Pragmatic Works office. They’re a part of the Pragmatic Works foundation, a non profit organization created to help unemployed, underemployed, and returning veterans gain the skills needed to gain access into the IT industry as...
22 October
2013
Author: TyroneBrown

PASStv Sessions Available On-Demand

PASS Summit 2013 has ended, but all the sessions from PASS Summit 2013 are available online now for on-demand streaming.

 

PASStv On-Demand Replay