Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I'm currently trying to implement Snowflake's Query_Tag functionality within a number of reports to start tracking associated costs down to the workspace/report level. I'm able to implement the following in Snowflake's Worksheets and the query run successfully. The query tag is loaded as expected in Snowflakes history query tag field.
Example of the SQL currently being used;
---
ALTER SESSION SET QUERY_TAG = 'Workspace - Report';
SELECT *
FROM View
---
However, when I try to load the following SQL into the snowflake connector I get the following error.
I'd like to understand how to implement this via a native connect if possible. Has anyone had success getting this to work?
I had this same issue and wanted to track the cost of the PBI reports. I couldnt get the actual QUERY_TAG to work however a workaround we are doing is adding the query tag statement at the end of the query as a comment and then parsing out the QUERY_TEXT from ACCOUNT_USAGE to get the usage of the report. Hope that helps
I'am interested too. I tried to pass an ALTER SESSION statement in the connection (with or without semicolon) :
But I have this error : Expression.Error: Native queries aren't supported by this value.
However I have a query in my Snowflake account
I don't understant why Power BI encapsulate my query in a select * FROM ?
It doesnt work - please vote for the idea: https://ideas.powerbi.com/ideas/idea/?ideaid=50dd3f43-7595-ec11-826d-501ac5249847
Did anybody get this to work?
No - The Snowflake connector needs to be updated to allow for the following.
I'm also interested in a solution for this for tracking reporting costs. In Tableau we can use 'Initial SQL' to accomplish this. However, Power BI seems to lack this functionality.
@Anonymous
Thanks - Both of those options are not resolving the issue. When we move the semicolon it causes additional errors.
Hi @jersey417 ,
1.It may casued by the semicolon in the end of the query,please delete it.
2. Please try @YMadden 's suggestion provided in this thread: Fully qualifying the table names as dbname.schemaname.tablename
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |