Connecting to SharePoint Analytics

Hi Anonymous 

Your screenshots show us the usage of your SharePoint site. So I think you want to get details of SharePoint site usage in Power BI Desktop to build reports.

Please try to connect to SharPoint Rest API in this link: SharePoint site usage reports

Try Web connector or OData feed connector to connect to SharePoint Rest API.

For example if we want to get site details by [GET /reports/getSharePointSiteUsageDetail(period='{period_value}')].

Each API has the requirement of permissions when we call this API. Please check the blog and give your account the API permission in Azure portal.

The url format is as below. Change your Server name, Site name in url and change ”period_value“(parameters) as requirement.

https://Server/Site/_api/reports/getSharePointSiteUsageDetail(period='{period_value}')

Select ok and sign in by your account which has access to this API.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Hi Anonymous 

Each rest api has its permission requirement. You need delegat permissions in your Application in Azure portal.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.