linked excel file should record information as 'data', not as a 'spreadsheet'
Instead of each question having its own column in Excel, there should be one column which contains the question number, another column with the question title, and another column with the response.
Essentially, each question/response would be a seperate ROW in excel, not all questions/responses on the same row.
Each row should also contain "KEY" information like the date, respondant's name etc.
This would enable us to analyse response in PowerBI much easier.
Please see the attached file. the DATA tab shows the prefered data format