PowerPivot on Lync – small update

Just a small heads up that I changed the Lync PowerPivot file to make it scale better.  In order to do so I have removed several unique columns from the import and moved some calculations to the query side instead of the client side.

I have placed the new file here and the original file is still available here.

If you are interested in having this as a Tabular Model (for SQL Server Analysis Services) please let me know.  You can easily do this yourself if you like of course by importing the model in the SQL Server Data Tools.

Comments (1)

  1. ATLExchGuy says:


    Great talk!!  I was wondering if you could lend a hand with the Media Type.  I can't figure out how you got this.

    Thanks in advance,


Skip to main content