Calling a Stored procedure in PowerPivot to populate your date table

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

While building a new PowerPivot workbook i wanted to use Time Intelligent functions. One of the golden rules of PowerPivot time intelligent functions is to create a seperate related time table. I have created a stored procedure which creates a new table in PowerPivot. The important thing to do is when you want to call a stored procedure withing PowerPivot is set the “SET NOCOUNT OFF” at the beginning of your sproc. This will make sure your stored procedure will return only one dataset.


Tags: dax, load, excel, time


2007-2015 VidasSoft Systems Inc.