Hi,
I have one Web Connector connected to a web service.
When I cerate a Web activity in a Data Pipeline and I use this connection, it retrieves me data as follows (json objects list):
Where each object should be a row in the table.
If I try to use the same conneciton in COPY activity, I get an error in the preview of the data:
Rest call failed with client error, status code 404 NotFound, please check your activity settings.
Response: <html>
<head><title>404 Not Found</title></head>
<body>
<center><h1>404 Not Found</h1></center>
<hr><center>nginx</center>
</body>
</html>
Any ideas of how to ingest data from web connector into lakehouse table?
When I set connection as variable content, it asks me in Source to select a lakehouse table. The source shouldn't be a lakehouse table but the content of the variable itself.
Helpful resources
Fabric Monthly Update - November 2025
Check out the November 2025 Fabric update to learn about new features.
Fabric Data Weeks
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
