Since the November 2024 Power BI release blog post announced that queries sent to Snowflake by Power BI include a query tag I’ve had a lot of questions from people who couldn’t see this happening or wanted to know what the query tags contained, so in this blog I thought I would outline the current status.
The query tagging feature for the Power BI Snowflake connector actually didn’t get released in November 2024 and even now, in April 2025, it’s only available for DirectQuery connections and Import mode refreshes that use the V1.0 connector (the V2.0 connector will support query tags soon). Here’s an example of what a query tag looks like for a SQL query generated by Power BI from a DirectQuery semantic model:
{"PowerQuery":true,"Host":"PBI_SemanticModel_MWC","HostContext":"PowerBIPremium-DirectQuery"}And here’s what a query tag for a SQL query generated for a semantic model refresh:
{"PowerQuery":true,"Host":"PBI_SemanticModel_MWC","HostContext":"PowerBIPremium-Import"}At the time of writing only SQL queries sent from the Power BI Service contain query tags, not those sent from Power BI Desktop. Also there is no way to customise the contents and unlike SQL queries sent to SQL Server-related sources there is no information on the report or visual that generated the SQL query. In the future some of these limitations may go away.
How and when would the on-premises gateway be tagged? Is it available currently?
Thanks for writing this, it is a long awaited functionality, I still don’t see query tagging happening though. From what I’m reading, there is really nothing that needs to happen for the tagging to take place other than to no be using the 2.0 connector. Is there something else that needs to be updated / enabled? Perhaps on-premise data gateway needs to be updated to a certain version too?
“ there is no information on the report or visual that generated the SQL query.”
Surely this is the primary use case?
I mean, yes. Surely. This is so basic. Still not working as far as I can tell.
What limitations are blocking the report and visual details that are included in the SQL Server tags from being included in the Snowflake tags? Any updates on when the limitations may be removed?