Transforming survey monkey data in Power BI via integration app and M Query

[Lycias]

Good day,

I have connected my survey monkey results to the Power BI desktop and would like to transform that data to build a summary dashboard of the results. In the survey, I had some questions that were multiple choice, some that were multiple option checkboxes, and some were comment boxes. How can I share this data for analysis, create a nice surry dashboard in Power BI, and have the transformations done so that if I refresh the connection if a new respondent submits, the analysis is automatically updated?

The link to the Excel version of the survey results extract is https://unaids-my.sharepoint.com/:x:/g/personal/zembel_unaids_org/EXv_E7lfVhtMlCNqGI2vKkwBwpQ8kMVBTj... 

Thanks,

Lycias