Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have quite a few tables that pick data from Snowflake which is my data warehouse system.
All the tables except of the customers one load fine even the orders table which is a massive size one.
With the customers is 2.5 million rows,I have already removed as many columns as i could and it takes a lot of hours to load when the others load in a matter of 10 minuites.Sometimes it shows to be loading over 3million rows when the entire table is actually 2.5 million
@Anonymous , That is strange, are you giving a query to the direct table? If you are using a query check that, also limit it with filter does it load fully.
Second check this table by taking this as a direct query and see does it work when using it in visual, is there a performance issue.
Also, increase the cache limit in option and setting; restart power bi and check does it make any difference
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |