Forum Discussion

Dom87326's avatar
Dom87326
Icon for Helper II rankHelper II
5 years ago
Solved

I’m having trouble retrieving Snowflake ODBC Data Source columns to Power BI?

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 

 

I am using ODBC instead of built in snowflake data source, because it doesn't have optional sql statement and I need that to limit fact data set on date field. The problem is that fact contains around 100 columns, but power querry editor loads only 25. I can't get my arms around why? Does anybody have any ideas?

 

Thanks!  

1 Reply