Am a keen follower of Microsoft's SharePoint Blog and proud to provide this direct from the Microsoft Tech Community:
Delivering data insight and intelligence is essential to reinventing your business processes. SharePoint provides a great system to aggregate data and documents, and to integrate Power BI based reports and dashboards across SharePoint employee experiences and Microsoft Teams. That’s why we’re pleased to share these three new white papers to help you learn how to deliver better Power BI reports throughout Microsoft 365 on the Microsoft TechCommunity Resource Center.
Using SharePoint and Teams as a Modern Dashboarding Platform
SharePoint has a long history of providing a first-class platform for business intelligence dashboards based on Power BI, Excel Online, Power BI Report server, and related tools. Adding conversations and other collaborative content brings context to the content and helps to foster a data culture. SharePoint pages, as well as lists, can be integrated into Microsoft Teams, bringing all this richness to the Teams collaborative environment. This paper will outline the various approaches to building dashboards in SharePoint, Microsoft Teams and SharePoint Server.
Using SharePoint as a data source for Modern Reporting
SharePoint is a great organizational data store. SharePoint lists offer a quick and easy way for users to store and share millions of items, while document libraries have become the industry standard for document management, supplying secure, reliable storage. There are several technologies for working with SharePoint data, such as Power Query, Excel, Power BI, SQL Server Reporting Services and SQL Server Integration Services. This white paper examines the different platforms and approaches that can be used to report on SharePoint data and explains the procedures.
Using Power BI with Complex SharePoint Field Types
SharePoint lists supply a quick and easy way for users to store and share millions of list-based items. Text and number fields are straightforward, but complex field types in SharePoint present several challenges. Power BI provides tools to aid with these challenges, and these tools are the focus of this white paper.
The above is kindly provided by the Microsoft Tech Community!