I want to connect my Power BI dashboard with excel hosted on Sharepoint with multiple sheets

[SaiKiran92]

I have an excel sheet on sharepoint with sales data for multiple weeks. I have a compleltely built dashboard which I want to connect to excel (all sheets included).

Each sheet in the excel file contains slaes data for a week. So, goal is to connect the file to the dashboard so I can compare the data for all weeks at a time. How is this possible?

[connect]

To connect your Excel sheet on SharePoint to your dashboard, you can follow these steps:

1. Open your dashboard and select the data source as Excel.
2. Choose the option to connect to an existing file.
3. Enter the URL of your SharePoint site and navigate to the folder containing your Excel file.
4. Select the Excel file and choose the sheets you want to include in your dashboard.
5. Follow the prompts to connect your data and customize your dashboard as desired.

If your Excel file contains multiple sheets with sales data for different weeks, you may want to consider organizing your data in a way that makes it easier to analyze and compare. For example, you could create a separate sheet that aggregates the sales data from all weeks into a single table or chart. Alternatively, you could use Excel's built-in pivot table and chart features to summarize and visualize your data in a variety of ways. Once you have organized your data, you can connect it to your dashboard and use it to gain insights and make informed decisions about your sales performance.