Share
ReportI have an excel table that pulls data from an external source and I am trying to pull that table in power automate but I get the following error:
The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net", "clientRequestId": "16cdc84d-4082-49ee-b4a3-89c4fc95f785", "message": "BadGateway", "innerError": { "status": 502, "message": "This workbook cannot be edited because it contains the following features:\r\n\r\n• Web queries\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy.\r\nclientRequestId: 16cdc84d-4082-49ee-b4a3-89c4fc95f785", "error": { "message": "This workbook cannot be edited because it contains the following features:\r\n\r\n• Web queries\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy." }, "source": "excelonline-eus2.azconn-eus2.p.azurewebsites.net" } } }
I read somewhere that to fix this problem you have to save a copy of the excel file and pull from the copy. I tried doing this in power automate using the copy file block for OneDrive, but this results in the same error. Is there any way that I can get the rows from the excel table without manually creating a new file? I would like this process to be automated. Thank you.
Categories:
All responses (
Answers (
243
