Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |