Hi all,
I've used powerQuery to my Excel and called to Sharepoint List using PowerQuery. Then i created a chart using using that list data. When i refresh the list (under WorkBook Queries it gives updated data).
Then i saved that spreadsheet and uploaded to sharepoint online document library. I need to refresh data from the browser too.
I could see there is Data button which has Refresh Selected Connection as an option. It gives following error once i clicked on Refresh Connection button.
'select a refreshable region, such as pivot Table before clicking on the refresh selected connection button'
Thank you