power bi query to snowflake

[mdamen123]

Hi everyone,

For an assignment, I'm developing a dashboard in Power BI where data is fetched from a Snowflake database in Power Query mode. When I filter, for example, on 'column A' and it should be 'red', I see in Snowflake that a query is generated from Power BI with a where clause like "where column A = ?". Why is there a question mark here, and what does Power BI do with it?

Thanks in advance!

[lbendlin]

the question mark is a placeholder for a value that is provided from outside the query (in this case by Power BI)

[mdamen123]

Thank you for your response. I have another question about it, does this mean that Power BI retrieves data from Snowflake for all possible values of the question mark (for example also 'green' and 'blue') and only proceeds further in Power BI by filling in the question mark?