Forum Discussion

TheoZuni's avatar
TheoZuni
Regular Visitor
2 months ago
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  ...
Need Help
  • jgeddes's avatar
    jgeddes
    2 months ago

    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.

Kedar_Pande's avatar
Kedar_Pande
Super User
2 months ago

TheoZuni 

The SQL Statement box is hidden because you have Implementation set to 2.The SQL Statement box is hidden because you have Implementation set to 2.0. The new 2.0 Snowflake connector removed the custom SQL Statement option.

  • TheoZuni's avatar
    TheoZuni
    Regular Visitor
    2 months ago

    Hi Kedar, there is an option to disable it?

  • TheoZuni's avatar
    TheoZuni
    Regular Visitor
    2 months ago

    I already fix it, a disable the option of the new experience, but i found it at the end we need to scroll down, the thing was that at the beginning has the option to use the legacy connection but it's no the right option