Forum Discussion
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...
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.
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
