I have a database in SQL Server, and want to implement an application that runs both SQL and DAX queries. For that, I installed SQL Server Analysis Services (SSAS) and the SQL Server Management Studio (SSMS) plugin. I created a Tabular Model project in Visual Studio, and I can import/load tables from SQL Server to Analysis Services, but that recreates all the tables. I need to have the data in a single place, due to two reasons (1) the database is large, and (2) whenever I update the SQL Server database that needs to be reflected in Analysis Services.
I tried the option "Add Data Source" (see below) in the Visual Studio project, but that didn't help. How to keep SQL Server and Analysis services synchronized without reloading the tables? What best practices are followed to build a data warehouse that supports both DAX and SQL?
