Power Query Editor SQL - use query results in SQL

Hi All.

I got an answer from this forum on my previous post... Now I need to continue to advance.

I would like to add the results of a query to my SQL. By Filtering the results in the SQL, It runs much faster.

Last post I asked and learned how to add an excel range to my sql in the advanced editor. Now I want to add the results of a query in my sql..
Last post I learned to ...

Please Login or Register  to view this content.

Now I want the results of POWER query (named "PN Listing") to be used instead of excel_range_creator_to_include - excel range can not be larger than 100 rows... I am guessing below

Please Login or Register  to view this content.

what is the syntax needed for the line power_query_results_to_include = "'" & ---- PowerQuery("PN Listing")--------- & "'",

Thanks.
Steve
Harrisburg, PA

So you want to use PQ result to your IN statement list?

Lets say that your query for the list is named myQuery, and has column named PN.
You'd then use Text.Combine, much like what you did with Excel list.

Please Login or Register  to view this content.

Note that doing so, will create query dependency and depending on data security settings, you may get Formula Firewall error. If that is encountered, you can deal with it in 2 ways.

1. By combining 2 queries into single query.
2. By setting data security level for both queries to be same (ex. both set to Organizational level security).

You are welcome