Integrating Excel into Power BI

详细信息

I have a an excel spreadsheet created via microsoft forms that has 25-30 responses via a survey. These questions are split into sections.I need to generate pie charts per individual question and an aggregated charts per section.This requires it to be set up so that the source data can be changed at will (spreadsheet will remain the same, but number of respondents and responses will alter)