Forum Discussion
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
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!
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
3 Replies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHey 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
