Data Collection from different resources and make dashboard reports

Hi Harpreet1405_12 ,

To create a centralized dataset in Power BI, you can use Power Query to connect to your different data sources (Excel, Word documents, OneDrive, etc.) and transform the data as needed. Once you have your data in Power Query, you can create relationships between the different tables and then load the data into a single dataset. To create live dashboards, you can use the Power BI service to create reports and pin visualizations to a dashboard. You can also set up data refresh schedules to ensure that your data stays up-to-date.

Create a Power BI dashboard from a report - Power BI | Microsoft Learn

To create a dynamic website of dashboards, you can embed your Power BI dashboards and reports into a SharePoint page or website using the Power BI web part. This will allow you to display your dashboards and reports directly within your SharePoint site, and users can interact with the visualizations just as they would in the Power BI service.

Embed a report web part in SharePoint Online - Power BI | Microsoft Learn

Best Regards