Excel Connector Issue in Copilot Studio for Agent using SharePoint as Knowledge Source

I faced the same 404 error with the Excel Online (Business) connector. Make sure the full SharePoint site URL is used (including https://), and that the document library name, file name, and table name match exactly. Also, try opening the file once in Excel Online to ensure it’s fully available. Still buggy in Copilot Studio, but using static values with correct paths helped me move forward. Hope this helps!

I have the same issue while trying to add Excel connectors to my Copilot Agent. It's really frustrating.

• If i don't use static value, AI cannot fill them correctly
• If i use static value, it doesn't work and keep returning 400 404 error

I really need a video instruction from Microsoft team but can't find them anywhere (youtube, microsoft community).

This is why I prefer using other easier Agent apps like Make, n8n which make what Copilot Agent took 3-4 hours of my time to setup (but failed) turns to 20 minutes or less. The only reason why I'm still trying this is due to company data policies. But please Microsoft! I'm begging for more video instructions, examples, not just text.

Sorry for the rant, this problem has been haunting me nearly 6 to 8 hours without success. 

Hope a clear solution is given.

Did you figured it out? I'm facing the same issue. 
I tried to connect to Excel get row (Business) from the Actions section. I also tried directly from the topic from node, Add an action and then Connector (preview) with same results "Error Message: The connector 'Excel Online (Business)' returned an HTTP error with code 404. Error Code: ConnectorRequestFailure"

I'm specifying the Sharepoint url, without including https:// as I read in some other post, Document Library, File and Table. I needed to enter manually.

Thanks