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.
Go to 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.
View solution in original post
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
Thank you, it helped !
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!