Forum Discussion
Solved
I’m having trouble using SQL in DirectQuery mode with Snowflake data source
Hello, I have two tables. A table that defines a user activity data (number of logins and etc.) Many tables with different dimensions (user demographics and etc.) Dimensions 1:* Fact B...
Hey Dom87326 ,
you can use direct query with snowflake:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake
Just try it and let us know if it works.
Best regards
Denis
Hello selimovd ,
Thanks for you input, but it's actually 330M rows. Regarding snowflake, I really want to know whether advanced options, SQL query window exists in direct query? This is something we have with odbc as data source for example.
Hey Dom87326 ,
you can use direct query with snowflake:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake
Just try it and let us know if it works.
Best regards
Denis