Forum Discussion
Solved
SQL Statement opcion error
Hi Masters, do you know something about that there is no SQL Statement opcion when I try to connect with Snowflake? I tried in settings to see if there something there but I didn't find anything ...
If you are using the lastest update of PBI and have the 'New Power Query experience' turned on in the Preview features option you are running into a bug. If the new experience is turned on, turn it off and try the data connection again.
I have this on the settigns
danextian
Super User
Super UserAs jgeddes, uncheck New Power Query Experience. The option will reappear.
If you prefer the new experience, I suggest to copy the connection code in the query editor and re-use it next time. Just manually edit the SQL statement.
I Tried this but once is create didn't allow to edit the query, didn't show the gear, and also I tried with the check in use the legacy snowflake connector, restart and nothing happens