plumbing params to the query rather than rows

[db042190]

Hi, I just added my first param.  And plumbed it to a column produced by my data source query.  What if i want to plumb it to the query iteself?  For instance in the datasource query's dax calculate function instead of a condition ending in >=datevalue("01/01/2015"), having a param replace the date string?

[Anonymous]

Hi @db042190,

According to your description, you want to use the query parameter at power query side, right?
If this is a case, I'd like to suggest you refer to below article.

How to pass the date parameters in PQ Query?

Regards,

Xiaoxin Sheng

[db042190]

depends.  Is my dax query converted to PQ behind the scenes?  And then i would need to get to the PQ query and modify it to use my param?

[Anonymous]

Hi @db042190,

No, dax formula not affect the power query, it only works on data model who generated by power query source data table.

The only way is use query parameter to effect power query source data.

Regards,

Xiaoxin Sheng

[db042190]

thx Xiaoxin.  Trying to understand.  I'm not sure what PQ is.  It looks like an excel transformation feature.  I have a tabular model.  Not excel.  Are you saying that the only way to get PBI parameters to "substitute" for conditions in a query is for the query to be PQ in the first place?

[Anonymous]

Hi @db042190,

Actually, power bi use power query function to get data from other sources.(you can click on 'edit queries' to enter to the query editor)

Processing steps:
1. Power query get data from other source and convert to table.
2. After you exit the query editor, power bi will analysis these tables and generate the matched data model.

Dax formula are based on these data model, it isn't affect the source data.

Regards,

Xiaoxin Sheng

[db042190]

thx.  I saw pbi work with a dax query.  can conditions in that dax query be substituted by parameters?  or only conditions in a PQ query?  Trying to understand.  I will be sitting with someone soon who might shed some light on the whole subject.

[Anonymous]

Hi @db042190,

Power query with query parameter is filter on source data, it will effect generated data model. dax formula works on data model, so it will also been affected.

Regards,

Xiaoxin Sheng

[db042190]

thx, so if i am providing a dax query to pbi, and i want pbi params to be sustituted for some kind of symbolic placeholders in my query, how do i do that?  If i'm not understanding, that's ok because i'm going to be getting clarification on this subject in person in the coming days.