Category: SSAS

SSDT Analysis Services and Reporting Services Projects in Visual Studio 2017

If you try to open old Analysis Services smproj or Reporting Services projects in Visual Studio 2017 you may run into an unsupported error. To install the required templates, go to: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects Select the Download link: Then for Reporting Services go to: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio Select Download: You will now be able to create and load analysis services and reporting services projects in Visual Studio:  

Create Tabular Model in SSAS 2016

We will go through an example of how to create a new tabular model in SQL Server Analysis Services 2016 (SSAS). Open SQL Server Data Tools (SSDT) and create a new Analysis Services Tabular project:   A new project will be created: Model.bim contains the following properties: Add data source connection: Connect to SQL data warehouse: To add tables to the model, click Model->Existing Connections: Open: Mark the date table as … Continue reading Create Tabular Model in SSAS 2016