Snowflake's Query_tag functionality in Power Query?

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 ?

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

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.

Anonymous 

Thanks - Both of those options are not resolving the issue.  When we move the semicolon it causes additional errors. 

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.

Did anybody get this to work?

We have successfully determined how to calculate credit consumption for each Power BI dataset run against the Snowflake database. With the recent Power BI release, we observed that the query tag column in the Snowflake usage history table is now being updated. This column includes a unique activity ID that remains consistent across all tables triggered from the dataset. By leveraging this unique activity ID, we can group all related queries and accurately determine the credits consumed for each run.