从SharePoint站点分析中获取数据
我希望从SharePoint（例如Daily用户）中获取网站使用数据，单击“速率”，这些网站的哪些部分使用最多的链接，他们使用的最多的链接，哪些文档正在打开最多。有没有一种方法可以通过Excel，任何程序等进行此操作。我一直在研究Power BI，Excel，Power Query等。我还没有找到一种从SharePoint Analytics本身中获取数据的方法。 我希望从SharePoint站点中获取数据并将其显示为图表，例如帕累托图。
I am looking to pull site usage data from sharepoint such as daily users, click through rate, which parts of the site they are using the most, which links they are using the most, which documents are being opening the most. Is there a way to do this through excel, any programs, etc. I have been looking at Power BI, Excel, Power Query, etc. I haven't found a way to pull the data from sharepoint analytics itself though.
I am looking to pull data from the sharepoint site and display it as a chart, a Pareto chart for example.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
1.现场使用分析页面可以导出的当前情况：
站点所有者可以通过进入站点使用页面右上角的“下载”按钮来将90天站点使用数据导出。报告独特的观众，现场访问，流行的平台和现场流量。对于网站上的流行内容（新闻发布，文档和页面），该报告将在过去7天内。
excel_example
2.我也尝试从excel中获取网络数据工作。目前，站点使用和PowerBi之间只有一个连接器。
我在 excelor in offor 。您可以随时投票并发表评论。
3.您可能会尝试使用Office 365 Admin API使用，检索和存储数据在数据库中，然后使用PowerBi进行报告。这需要在Azure AD上注册，并将其授予API。
参考： Office 365管理活动API参考
1.The current situation that the site usage analysis page can export:
Site owners can export the 90-days site usage data in an excel file by going to the download button in the upper right corner on site usage page. Report on unique viewers, site visits, popular platforms and site traffic. For popular content on the site (news posts, documents and pages) the report will be for last 7 days.
excel_example
2.I've also tried getting data from the web in Excel, but it doesn't work. There is currently only one connector between site usage and PowerBI.
I tracked down a published post in UserVoice: Export to Excel on Site usage. You can vote and comment anytime.
3.You might try using the Office 365 Admin API to use, retrieve and store the data in a database, and then report on it with PowerBI. This requires registering with Azure AD and give it permissions to the API.
Reference: Office 365 Management Activity API reference