I’m having trouble using Snowflake data source advanced options

[Dom87326]

Hello,

I am getting an error when calling a table in snowflake stating the following:

"This native database query isn't currently supported".

I have already unchecked the checkbox under Options-->Security--> "Require user approval for new native database queries" and tried simple SELECT 1 FROM some_table.

I'm trying to run this query: 

SELECT * from some_table
WHERE Column1 = 'ABC'
AND "Date" BETWEEN DATEADD(YEAR,-1,"Date") AND 'yyyy-mm-dd' 

Does anyone know what might be causing this?

Thanks! 

[Anonymous · Accepted solution]

Hi @Dom87326 ,

You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues.

If it is not there, then you could post it.

Best Regards,

Jay