使用 Azure Synapse 将文件从 Sharepoint 复制到 Azure Data Lake gen 2

发布于 2025-01-17 14:21:10 字数 791 浏览 1 评论 0 原文

我正在尝试使用 Azure Synapse 管道将文件从 Sharepoint 复制到 Azure 数据湖 gen2

我已经设置了先决条件并配置了文档中提到的管道 (https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online )

Web 成功并将令牌传递给复制数据活动。但是,我在水槽侧遇到错误

在此处输入图像描述

获取以下错误消息

<图像src="https://i.sstatic.net/zbMM9.png" alt="在此处输入图像描述">

不确定问题是什么?有人可以建议吗?我参考了各种帖子但没有成功

I am trying to copy files from Sharepoint to Azure data lake gen2 using Azure Synapse pipeline

I have set up the prerequisites and configured the pipeline as mentioned in the document (https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online)

Web succeeds and passes a token to the Copy Data activity. However, I am getting the error in the sink side

enter image description here

Getting below error message

enter image description here

Not sure what is the issue? can anyone advise? I referred various posts but no success

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

秋心╮凉 2025-01-24 14:21:10

错误 – 远程服务器返回错误:(401) 未经授权。

出现此错误是由于身份验证问题。

此操作需要 SharePoint Online 网站所有者权限。你
可以通过进入网站首页->找到失主单击“X
右上角的“成员”-> 检查谁具有“所有者”角色。

同时检查

即使 Azure AD 应用程序具有 FullControl 权限
SharePoint Online,您无法使用以下命令从文档库复制文件
已启用 IRM。

请参阅 - https://learn.microsoft.com/en-us/answers/questions/381621/copy-data-from-sharepoint-using-adf-1.html

Error – The remote server returned an error: (401) Unauthorized.

This error occurs because of authentication issue.

This operation requires SharePoint Online site owner permission. You
can find the owner by going to the site home page -> click the "X
members" in the right corner -> check who has the "Owner" role.

Also check

Even if an Azure AD application has FullControl permissions on
SharePoint Online, you can't copy files from document libraries with
IRM enabled.

Refer - https://learn.microsoft.com/en-us/answers/questions/381621/copy-data-from-sharepoint-using-adf-1.html

雪花飘飘的天空 2025-01-24 14:21:10

几周前,我在同一文档后遇到了同一问题。

我能够通过启用自定义应用程序身份验证来解决问题。对于2018年11月11日之后创建的SPO租户,默认情况下禁用了ACS ACS ACS访问令牌身份验证(请参见下面的链接中的蓝色框)。

我决定在使用Azure Data Factory将多个文件从SPO文件夹中移动到BLOB存储的如何将多个文件移动到BLOB存储,也许您会发现它很有用:

从SharePoint复制blob存储< /a>

A few weeks ago I ran into the same problem following the same documentation.

I was able to solve the problem by enabling Custom App Authentication. For SPO tenants that were created after 07.11.2018 the authentication via ACS app-only access token is disabled by default (see blue box in link below).

Granting access using SharePoint App-Only

I decided to write a blog post with a step by step guide on how to move multiple files from an SPO folder to Blob Storage using Azure Data Factory, maybe you will find it usefull:

Copy files from SharePoint to Blob Storage

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文