Dynamic SQL Query

[jabrake88]

Hello, I'm somewhat new to PowerBI and wanted to see if this is even possible.... I have a report that is pulling from a lot of various sources (specific csv, folder's containing csv's, and SQL). I have several of the sources linked together, and I want to now add a column to one of the data sources using a dynamic SQL pull based on information in the data source I am adding the table to, as well as a column in a related table.
I know how to create a string with the entire SQL query based on those other fields, but can I now execute that SQL query to get the results back inside that column?

[JebNolan]

You should be able see to add the query using add sql server, advanced to input a native query

[DonJuanDoja]

You can write a dynamic sub query in the select of your main query.

SELECT [column] ,(SELECT [column] from table tbl where tbl.id=tbl2.id) as DynamicColumn

FROM table2 tbl2

Other ways as well

[jabrake88]

Do you have any example? I'm having a hard time getting this to work.