SharePoint 2013 - Cool Writeups dot com and Certified Solutions Australia dot com by Derek Halstead

Analysis Services TABULAR SQL Server Data Tools Import Power Pivot Project

Analysis Services TABULAR SQL Server Data Tools – How to Import Power Pivot Project

Step by step

Open SSDT as an Administrator on your DEV machine.

OpenSSDTAsAdmin

 

Create a new Project to Import from Power Pivot and give your project a name.

NewProjectToImport

 

Connection to ‘Analysis Services – Tabular’ on your server should always be YourSQLInstance\TABULAR

TestConnection

 

Copy your Power Pivot files to a folder on the Analysis Server such as D:\PowerPivotFiles and share it like so – \\YourServer\PowerPivotFiles

PowerPivotShared

 

Give the service account that runs Analysis on the SharePoint/Analysis server READ rights to the folder that hosts the Power Pivot files.

AnalysisServicesServiceAccount

 

FolderSecurity

 

Select your file to import into your Visual Studio project.

Troubleshooting – Use Process Monitor to debug access to the Power Pivot shared folder when experiencing issues.

Derek Halstead is a SharePoint consultant, educator and author, as well as the founder and principal of Certified Solutions Australia and CoolWriteups.com. He has 16 years of experience in the IT industry, with over ten years focused on Microsoft SharePoint. He can be reached by using the Contact Me link in the top menu.