Limitation with multiple values in query load

[Rynke]

Hi Experts,

I have below two connections i PQ.

I would like to limit connection 1, to only include rows that are in connection 2.

I was hoping to cut off som loading time, if I could do the limitations directly in the query load, instead of doing a merge afterwards.

I know how to do this with a single cell input from Excel, directly in the WHERE clause. But what if I want to load several items?

Can I make a join of below connections (I have tried without luck, but still a newbie), or is there another way?

PS. The items in Table1 is matching with table FSLEDG.ESVONO

(Connection 1: More than 10 mill. rows)

Odbc.Query("dsn=M3_PROD", "SELECT FSLEDG.ESVONO#(lf)FROM M3.M3FDBPRD.FSLEDG FSLEDG") 

(Connection 2: a table in Excel)

Excel.CurrentWorkbook(){[Name="Table1"]}[Content]

/Rynke

[Rynke · Accepted solution]

I found below homepage, which gave me a solution I understood.
It gave me what I needed, even though the loading process can be very long, if there is too many rows and columns in my table.

https://powergi.net/2020/05/17/dynamic-sql-queries-with-excels-power-query/

/Rynke

[v-yanjiang-msft]

Hi @Rynke ,

Please refer to the solution in the similar thread:

Solved: Filetring my table before importing in PowerBi - Microsoft Power BI Community

Solved: Filtering source in Power Query - Microsoft Power BI Community

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rynke]

Hi @v-yanjiang-msft 

Thanks for your reply.

I've been looking through both threads, and maybe I'm still just too newbie 😉

For me it looks like the parameters created is on a single value, I need more than one.

Furthermore it seems that in "Data source settings", I don't have same possibilities, where I can use a parameter directly in the source...

/Rynke