Using survey monkey data

[amrenkin]

Hello, When using Survey Monkey data to transpose into bar graph display do you have to download the results as a CSV. doc? I have a series of about 12 questions and about 13 people who respond to each question. They can pick from a series of answers (Occasionally, , Often, Seldom, Always and Never) and in graphing it I need Occasionally to be the median on the vertical axis. I'm trying to figure out if this can work for my data. I've been using excel but it is very time consuming

[darleen1]

This may become an issue if your survey data becomes large enough. If you have a survey that you expect to grow to several thousand responses, then CSV may at certain point become your only file download option. For this reason, I always choose the CSV version from the beginning for all my ongoing SurveyMonkey surveys. 

[v-yuezhe-msft]

@amrenkin,

Do you want to directly connect to Survey Monkey in Power BI? If so, please firstly contact Survey Monkey support about that if it supports OData service or provides REST API to get data, it is possible to connect to OData service or REST API in Power BI Desktop.

There is also an idea about Survey Monkey, please vote it up.

Regards,
Lydia

[amrenkin]

No I just need to take the data from a Excel sheet and turn it into a bar chart. I guess I'm not understanding how this can save me time? Do you know of a tutorial that will help more? I'm not savvy when it comes to these things and the Getting Started video didn't help much.

[v-yuezhe-msft · Accepted solution]

@amrenkin，

To import data from Excel to Power BI Service, please review this article: https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files.

To import data from Excel to Power BI Desktop, please review this blog:https://www.red-gate.com/simple-talk/sql/bi/importing-excel-data-power-bi-desktop/.

Regards,
Lydia