Forum Discussion
Limitation with multiple values in query load
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
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
3 Replies
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
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
