In Navigator, select the check box for the following tables: DimCustomer, DimDate, DimGeography, DimProduct, DimProductCategory, DimProductSubcategory, and FactInternetSales. This creates the connection to the database. In Navigator, select the AdventureWorksDW database, and then click OK.
#SQL NAVIGATOR TUTORIAL WINDOWS#
If your datasource is an on-premises or VM SQL Server Data Warehouse, choose Windows > Impersonate Account, and then enter an account name and password. Select Microsoft account, and then click Sign in. When prompted to enter credentials, you need to specify the credentials Analysis Services uses to connect to the data source when importing and processing data. If you created an Azure SQL Data Warehouse with the AdventureWorksDW sample database, you can copy the server name from the Overview page in the Azure portal. In the SQL Server Database dialog, in Server, type or paste the name of the server where you installed the AdventureWorksDW database, and then click Connect. In Get Data, click Azure > Azure SQL Data Warehouse, and then click Connect. If you don't see Tabular Model Explorer, in Solution Explorer, double-click Model.bim to open the model in the designer. This launches Get Data, which guides you through connecting to a data source. In Tabular Model Explorer, right-click Data Sources > Import from Data Source. Create a connection To create a connection to the AdventureWorksDW database Before performing the tasks in this lesson, you should have completed the previous lesson: Lesson 1: Create a new tabular model project. This article is part of a tabular modeling tutorial, which should be completed in order. In some cases, an AdventureWorksDW database on SQL Server Data Warehouse may show different objects however, they are fundamentally the same.Įstimated time to complete this lesson: 10 minutes Prerequisites Tasks and images in this tutorial show connecting to an AdventureWorksDW database on an Azure Synapse Analytics resource.
0 kommentar(er)
