Excel PowerPivot with SQL Storage Areas
Does anyone have experience with extracting SQL storage area data and importing into Excel PowerPivot? Trying to avoid using the SQL Server Management Studio. I want to be able to sort data by piece description since the find feature in Accumark Explorer does not support that. Any other suggestions?