Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data refresh keeps failing

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

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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