Forum Discussion
Connecting to SharePoint Analytics
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!
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.
5 Replies
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 , there is a rest API if you can use that, see if this can help
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.
