Forum Discussion
Limitation with multiple values in query load
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
Community SupportHi 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.
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