Forum Discussion
power bi query to snowflake
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!
2 Replies
- lbendlin
Super User
the question mark is a placeholder for a value that is provided from outside the query (in this case by Power BI)
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?
