cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyMartini
Frequent Visitor

Can't Use Excel workbook because it uses web queries

I 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.

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Kudoed Authors
Users online (2,261)