Dynamic M Parameters to run multiple queries?

[alaynanich]

Hi PBI Community,

I was looking for a way to be able to feed a table to Power Query and dynamically run the same query using paramters, sort of like this article https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

But my need is that for the sample table below, I want each individual row to be ran in its own query. For example, lets say the query for my sales db table is :

select * from A.sales

where sku is in ('XXX')

and sales_date between '2024-01-01' and '2024-01-02'

With the table below I want to only pull sales for sku 7002861 between Jan 1 and Jan 7, sku 7022746 between Dec 25 and Dec 31, and so on. Then have these sales results concatenated into one total sales query. Is it possible to do this using the dynamic query example above? I want to avoid pulling all sales and then using a measure to filter because in reality I would have hundreds of millions of rows to pull each year and only want to pull the actual sales info I need. If anyone is familiar with Alteryx, this is accomplished using the dynamic input tool to edit the query with each input. Thanks!

[amitchandak · Accepted solution]

@alaynanich , Dynamic M Parameter is for Direct query mode.

You can have measure like , once you have both tables in power bi

Sumx(SKU, sumx(filter(Sales, Sales[SKU] = SKU[SKU] && Sales[Date] >= SKU[Start] && Sales[date]<= SKU[ENd]) , Sales[Value]))