Power Query Refresh is now generally available in Excel for the web

Copper Contributor

Jun 13, 2024

Hi,

I'm having problems with refreshing powerquery with excel online. There are no issues if the workbook is opened in the desktop app. All sources are within the workbook. I get the error:

Couldn't refresh data

We were unable to refresh the query: Current Cases Data Table.DataSource.Error: Web.Contents failed to get contents from 'https://auc-excel.officeapps.live.com/x/_layouts/xlrestinternal.aspx?ui=en-US&rs=en-US&dchat=1&dchat=1&hid=E92832A1-B07F-3000-6137-6D7CCC8E469D.0&WOPIsrc=https%3A%2F%2Fxxxxxxxxxxxx.sharepoint.com%2Fsites%2Fxxxxxxxxxx%2F_vti_bin%2Fwopi.ashx%2Ffiles%2F7b3466044a094be496b4fcc755a864b7&access_token=eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IkRhREFmalFRbXB5T1h4MlJyS19XNWx2b0xaNCJ9.eyJhdWQiOiJ3b3BpL21lZGljYWxyZXNjdWVjb21hdS5zaGFyZXBvaW50LmNvbUA0ZTljODJkNi00NGI4LTRjYjgtYTUzNS04ZTYzNGZiYzY0ODIiLCJpc3MiOiIwMDAwMDAwMy0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAOTAxNDAxMjItODUxNi0xMWUxLThlZmYtNDkzMDQ5MjQwMTliIiwibmJmIjoiMTcxODI2MTc2MCIsImV4cCI6IjE3MTgyOTc3NjAiLCJuYW1laWQiOiIwIy5mfG1lbWJlcnNoaXB8bG9ic2hvbGVAbWVkaWNhbHJlc2N1ZS5jb20uYXUiLCJuaWkiOiJtaWNyb3NvZnQuc2hhcmVwb2ludCIsImlzdXNlciI6InRydWUiLCJjYWNoZWtleSI6IjBoLmZ8bWVtYmVyc2hpcHwxMDAzMjAwMDk0MWUwOTJmQGxpdmUuY29tIiwic2lkIjoiZGE5ZmI0YTctOGIwYi00MGJlLTg2ZmQtN2ZiYjgyYzc1MzlkIiwic2lnbmluX3N0YXRlIjoiW1wia21zaVwiXSIsInhtc19jYyI6IltcIkNQMVwiXSIsInhtc'

(400): Bad Request

https://auc-excel.officeapps.live.com/x/_layouts/xlviewerinternal.aspx?unified=1&ui=en-US&rs=en-US&wopisrc=https%3A%2F%2Fmedicalrescuecomau.sharepoint.com%2Fsites%2FSnowyHydro%2F_vti_bin%2Fwopi.ashx%2Ffiles%2F7b3466044a094be496b4fcc755a864b7&wdsle=0&wdenableroaming=1&mscc=1&hid=E92832A1-B07F-3000-6137-6D7CCC8E469D.0&uih=sharepointcom&wdlcid=en-US&jsapi=1&jsapiver=v2&corrid=df0dad7a-4158-60f1-15e8-e0282a5f2c8b&usid=df0dad7a-4158-60f1-15e8-e0282a5f2c8b&newsession=1&sftc=1&uihit=docaspx&muv=1&cac=1&sams=1&mtf=1&sfp=1&sdp=1&hch=1&hwfh=1&dchat=1&sc=%7B%22pmo%22%3A%22https%3A%2F%2Fmedicalrescuecomau.sharepoint.com%22%2C%22pmshare%22%3Atrue%7D&preseededsessionkey=4245d857-354b-5768-e31d-f8c2a4c319fc&preseededwacsessionid=df0dad7a-4158-60f1-15e8-e0282a5f2c8b&ctp=LeastProtected&rct=Normal&wdorigin=ItemsView&wdhostclicktime=1718261759506&wdredirectionreason=Force_SingleStepBoot&xlel=1&instantedit=1

The script I'm using to receive data is:

let

Source1 = Excel.CurrentWorkbook(){[Name = "Lobs_Hole"]}[Content],

Blog Post

New in Excel for the web: Power Query Refresh is now generally available for selected data sources