Custom SQL instead of table or view

[PowerBIlearner]

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

@Seth_C_Bauer

@v-haibl-msft

@ImkeF

@Baskar

@Sean

Shruthi

[Seth_C_Bauer · Accepted solution]

@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 · Accepted solution]

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

[smadappa]

Thank you, it helped !

[Boyan]

...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) 

[Seth_C_Bauer · Accepted solution]

@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.