Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Multiple tables for a single dataset

Hello,

 

I'm trying to create a data set from one of my data sources. I would like to import multiple tables from a database of SQL Server, but I am not able to do so. Do you know if it's possible? I don't want just a single table.

 

Thank you

 

Nick

Data set
sql server
tables
  • Jon-Heide's avatar
    Jon-Heide
    8 years ago

    Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.

1 Reply

  • Jon-Heide's avatar
    Jon-Heide
    Microsoft Employee
    8 years ago

    Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.