SharePoint file statistic

[Anonymous]

I am working on a PowerBI report that shows the file activity in the company SharePoint site.

One of the requirement is to show number of views and viewers of the file, together with the date/time.   See image below:

I have tried various a few SharePoint data connectors but they don't give the data i need.  Can anyone help?

[V-pazhen-msft · Accepted solution]

@Anonymous 
It is one of the feature from SharePoint Server,check  the usage report.
Using Power BI for SharePoint Reports and Analytics (devfacto.com)
View and configure usage analytics reports in SharePoint Server - SharePoint Server | Microsoft Docs

You cannot set this with Power BI, you might need to go to SharePoint forum for more detailed explanation on the steps. SharePoint BI - Microsoft Tech Community]

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.