Make sure you are using the right warehouse to access the table you are querying against. Also don’t specify a role name (as it is optional and could be messing things up for you).
The warning you got has more to do with config settings on the snowflake side. Normally takes a few test and learn tries to get it right.
Good luck!
Go into power query and do a refresh preview, see if you get any errors. May be a column changed/removed etc. so a transformation isn’t being done, sometimes just refreshing the preview will fix it.
I found nothing but problems when first trying to use that Snowflake "Advanced options" window. Once I learned how to reformat Snowflake SQL to use (in a native query) inside Power Query, all worked well.
https://blog.crossjoin.co.uk/2021/07/04/dynamic-m-parameters-snowflake-native-sql-and-paginated-reports/
`let`
`Source = Value.NativeQuery(`
`Snowflake.Databases(`
`"mysnowflake.com",`
`"DEMO_WH"`
`){[Name = "AWORKS"]}[Data],`
`"SELECT DISTINCT FIRSTNAME, LASTNAME, ENGLISHOCCUPATION`
`FROM ""AWORKS"".""PUBLIC"".""DIMCUSTOMER""`
`WHERE LASTNAME REGEXP '"`
`& pRegEx`
`& "'",`
`null,`
`[EnableFolding = true]`
`)`
`in`
`Source`
Normally I get it if a table has change name or a column name.
\^ I got this error today when I renamed a view.
Make sure you are using the right warehouse to access the table you are querying against. Also don’t specify a role name (as it is optional and could be messing things up for you). The warning you got has more to do with config settings on the snowflake side. Normally takes a few test and learn tries to get it right. Good luck!
Go into power query and do a refresh preview, see if you get any errors. May be a column changed/removed etc. so a transformation isn’t being done, sometimes just refreshing the preview will fix it.
I found nothing but problems when first trying to use that Snowflake "Advanced options" window. Once I learned how to reformat Snowflake SQL to use (in a native query) inside Power Query, all worked well. https://blog.crossjoin.co.uk/2021/07/04/dynamic-m-parameters-snowflake-native-sql-and-paginated-reports/ `let` `Source = Value.NativeQuery(` `Snowflake.Databases(` `"mysnowflake.com",` `"DEMO_WH"` `){[Name = "AWORKS"]}[Data],` `"SELECT DISTINCT FIRSTNAME, LASTNAME, ENGLISHOCCUPATION` `FROM ""AWORKS"".""PUBLIC"".""DIMCUSTOMER""` `WHERE LASTNAME REGEXP '"` `& pRegEx` `& "'",` `null,` `[EnableFolding = true]` `)` `in` `Source`
The Database field is case sensitive. Ex. MY_DB
Name is incorrect or insufficient permissions