Data refresh keeps failing

[Anonymous]

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

[amitchandak]

@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