Forum Discussion

Helper II

5 years ago

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...

Need Help

selimovd
5 years ago
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

Most Valuable Professional

5 years ago

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