Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am trying to import data from a snowflake database table. When the data is imported 4 of the 10 columns are imported as completely empty ( all null values), however the column headers are correct.
I have also noticed that the columns which are empty are all obtained from a calculated function in SQL such as AVG or MIN. I don't know if this is related or not, but the table in snowflake shows the data correctly.
When I download the data from snowflake to csv and then import into snowflake, the data works just fine.
Solved! Go to Solution.
@Anonymous, I have used aggregated queries from snowflake and got the correct data. Open power query and check if there is an error related to data type. That can be an issue
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |