Forum Discussion

TheoZuni's avatar
TheoZuni
Regular Visitor
3 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
    3 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.

Shai_Karmani's avatar
Shai_Karmani
Icon for Super User rankSuper User
3 months ago

Hi, the SQL Statement box is inside the Advanced options expander on the Snowflake connector dialog. In Get Data, pick Snowflake, fill in your Server (and Warehouse if you use one), then click "Advanced options" - SQL Statement will appear there along with Role name, connection timeout, and a few other fields.

 

If that solved it, please mark it as the accepted solution and give a kudos.

 

Best,
Shai Karmani

 

Let's connect in LinkedIn