Forum Discussion

alisonpappas's avatar
alisonpappas
Icon for Helper III rankHelper III
6 years ago
Solved

REFRESH HELP!!!

Hi All,   Two problems I am running into. I have my data set connected to a file on SharePoint. In the server, when I click "refresh" nothing happens. Then when I go to the desktop app it times out...
Need Help
Show and Tell
Tips and Tricks
  • alisonpappas's avatar
    alisonpappas
    6 years ago

    I did not find a real solution, I have to delete and reupload the fle to work.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

I would also question why the query is taking so long to refresh.  However, if you need to override the default timeout limit, if you are using Web.Contents() to get your excel data, you can use the approach in this post

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat