Looking to refresh an Excel spreadsheet that has a table containing TFS data. Every day I'm having to manually refresh my Excel sheet that contains my TFS data along with my PowerPivot table thats linked to it as I have custom calculations that I display in PowerBI.
I would like to get to the point where I can automate this instead of having to do it manually each day.
Thanks!
