30 Nov’19

UncategorizedAdding Data Source to Tabular Model

In this blog we will see how we can add data source(SQL Server) to tabular model
Pre-requisite:

SQL Server with AdventureWorksDW2017 database

  1. Go to Tabular Model Explorer > Data Source and Click on Data source and select Import from data sourceand it will prompt to select data source, in this case we will select SQL Server database

Enter server name and enter credentials
And select the database

  1. Once we select database it will prompt to select the tables from the database and click on load
  2. Once clicked on load it will start importing tables from source database.
  1. Once table imported, we can see the Tables under tables section also relationships among them.

While importing it will automatically detect the relationships among the table, but if wanted to create the relationships we can create relationships.

So just we have seen how we can import data source into Tabular model.

Written by

Gurunath Vishwakarma

Associate Software Engineer- Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integrati...

    Read more
  • How to create AX (D365 F&0) Connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during integration of data. While performing Integration w...

    Read more
  • First cut review of new D365 Project Service

    12 December’ 2019

    The new Project Service coming up is a much-advanced version of PSA. Even more, than it will be called as Project Servic...

    Read more
  • Business Central Wave 2 Features – Section 4

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more
  • Business Central Wave 2 Features – Section 5

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close