Refreshing data from sharepoint spreadsheet

Managed to answer my own question so will post the solution incase any struggles in future. 

Sharepoint service does update in powerBI and can be done in the following steps:

1. Get data from sharepoint folder, use log in credentials to verify access to the files

NOTE: IF you get errors just use the master directory! not a specific folder and check your url is correct.

2. This returns a list of all the files in all the subfolders of the master sharepoint directory

3. Find your data in my case it was a simple excel spreadsheet, isolate it by removing all other rows and then expand the data

4. Transform data if you need to, apply changes and build reports, publish to powerBI service etc etc

5. Most important step! Set the schedule refresh settings and press refresh now by right clicking on the dataset in PBI service. See here:

You should now be able to use lists and spreadsheets stored in sharepoint and set them to update and refresh weekly/daily/hourly to keep your dashboards and reports up to date.