Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Shruthi
Solved! 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.
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
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
Thank you, it helped !
...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)
@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.