Forum Discussion

PowerBIlearner's avatar
PowerBIlearner
Frequent Visitor
9 years ago
Solved

Custom SQL instead of table or view

Hello,


Can you tell me how do I write the custom sql/ derived table to join to existing tables from the databases? I would like to be able to use derived table. The only options I see is I can use tables/views from the database. Thank you in advance.

 

ankitpatira

Greg_Deckler

BhaveshPatel

Anonymous

v-haibl-msft

ImkeF

Baskar

Sean

 

Shruthi

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    PowerBIlearner When you connect to the SQL Server you can expand the "Advanced options" and input a SQL query to pull in the data that you want.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi PowerBIlearner,

     

    When we connect to SQL Server data source, we can use derived tables in the T-sql query, you can refer to the sample below:

     

     

     

    Best Regards,
    Qiuyun Yu

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi PowerBIlearner,

     

    When we connect to SQL Server data source, we can use derived tables in the T-sql query, you can refer to the sample below:

     

     

     

    Best Regards,
    Qiuyun Yu

      • Boyan's avatar
        Boyan
        Helper I
        6 years ago

        ...and when you have 15 queries so that you want 15 datasets then you do the SQL conneciton 15 times - just genious on Microsoft's part (sarcasm) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    PowerBIlearner When you connect to the SQL Server you can expand the "Advanced options" and input a SQL query to pull in the data that you want.