Help Needed: How to Get Live Data from SharePoint and Teams into Power BI

[Anonymous]

Hello Power BI Community,

I am working on creating a Power BI report that integrates live data from both SharePoint and Microsoft Teams. I am relatively new to working with APIs and integrating such data sources into Power BI, and I'm running into a few challenges that I hope the community can help me with.

Report Requirements:

1. SharePoint:

   • Metrics Needed: Views, unique visitors, total visitors/views and which page they visit.
   • Historical Data: Ability to track this data over longer periods than the 90 days currently available.

2. Teams:

   • Metrics Needed: Members, replies, and reactions over time.
   • Challenges: There seems to be no straightforward way to download or access this data directly.

Specific Issues:

1. SharePoint Data:

   • I can only download analytics data for the last 90 days. How can I extend this period to keep historical data longer?

2. Teams Data:

   • I have not found a method to download or access data about members, replies, and reactions over time.

What I Need Help With:

1. Automating Data Retrieval:

   • Best practices for setting up automated data retrieval from both SharePoint and Teams.
   • Any examples or guidance on using Power Automate or other tools like APIs to achieve this.

2. Extending Data Retention:

   • How to store and manage historical data beyond the 90-day limit for SharePoint analytics.
   • Methods or tools to access and download data related to members, replies, and reactions from Teams channels and store historical data.

Additional Information:

I have basic knowledge of APIs and Power BI, so any detailed steps or examples would be greatly appreciated.

Thank you for your help!

[lbendlin]

You say live data but then you mention the need for historical storage.  Does not compute.

Power BI has no memory.  You need to manage your data storage further upstream, for example by storing the JSON extracts from the SP audit API on a OneDrive/Sharepoint (NOTE:  Ideally not on the one you are auditing!!!)

[Anonymous]

Sorry for a bad explaination. With live data, I mean that I don't manually have to pull out the data from Sharepoint/Teams. I just want a report with data that is automatically up to date with the latest data.

With historical storage, I mean the data should not be replaced, but rather add on to an Excel file for instance, so that I can track number of visitors each day over time in a few months/years in the future.

[lbendlin]

As I mentioned - it's all you.  Power BI only displays the data, it doesn't manage it.  Fabric will be a little (but not much) better in this regard.