I’m having trouble using SQL in DirectQuery mode with Snowflake data source

[Dom87326]

Hello, 

I have two tables.

1. A table that defines a user activity data (number of logins and etc.)
2. Many tables with different dimensions (user demographics and etc.)

Dimensions 1:* Fact 

Because fact table contains multiple millions rows, I'd like to use direct querry and partition based on date column. Is there any option to use sql in direct query mode with snowflake data source? I've read that this fueature should have been introduced in the beginning 2021 (https://blog.crossjoin.co.uk/2020/10/18/build-scalable-bi-solutions-using-power-bi-and-snowflake/).

Thanks!

[Dom87326]

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. 

[selimovd · Accepted solution]

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

[selimovd]

Hey @Dom87326 ,

how many million rows do you have? If it's just a few million Power BI should be able to handle that. The advantage then is that you have not limitations.

Otherwise you can use DirectQuery with Snowflake:

Connect to Snowflake computing warehouse in Power BI Desktop - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic