Forum Discussion

tlo11's avatar
tlo11
Frequent Visitor
4 years ago
Solved

Data Refresh in Desktop fails w/o opening data in PowerQuery

Hi there, I am facing an one issue with one of my desktop reports. I have created a fairly simple dashboard with several (local) Excel inputs that are wrangled with PowerQuery. When I replace the so...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    tlo11 , seem strange. Clear memory management cache and increase it to 8-10 GB supported by system RAM and virtual memory

     

    try some of these setting

     

    Make sure you have 20GB or more free on hard disk.  These can ensure data load

amitchandak's avatar
amitchandak
Super User
4 years ago

tlo11 , seem strange. Clear memory management cache and increase it to 8-10 GB supported by system RAM and virtual memory

 

try some of these setting

 

Make sure you have 20GB or more free on hard disk.  These can ensure data load

  • tlo11's avatar
    tlo11
    Frequent Visitor
    4 years ago

    Hey amitchandak,

    thanks- I did indeed help. I increased the possible RAM usage to 16GB (my machine does have 32GB) and cleared the cache. Thanks again!

  • JanRak's avatar
    JanRak
    Helper I
    1 year ago

    Hi
    Clearing the cache worked for me as well.
    Thank you for the tip!