Connecting to SharePoint Analytics

[Anonymous]

I would like to connect PowerBI with the SharePoint analytics for a more detailed dashboard view. I am currently able to see the SharePoint usage data, but have idea how to connect to it. here is an example of the data that I see.

Can anyone point me in the right direction? 

Thank you!

[Anonymous · Accepted solution]

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. 

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

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. 

[amitchandak]

@Anonymous , there is a rest API if you can use that, see if this can help

https://docs.microsoft.com/en-us/graph/api/reportroot-getsharepointsiteusagepages?view=graph-rest-1.0

[Anonymous]

@amitchandak I am still stuck on getting at the specific SharePoint on the organizational site. I think the issue is that I am not an overall SharePoint administrator. 

[Anonymous · Accepted solution]

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.