cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
amrenkin Frequent Visitor
Frequent Visitor

Using survey monkey data

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
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Using survey monkey data

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Using survey monkey data

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amrenkin Frequent Visitor
Frequent Visitor

Re: Using survey monkey data

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.

Moderator v-yuezhe-msft
Moderator

Re: Using survey monkey data

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 353 members 3,584 guests
Please welcome our newest community members: