Forum Discussion
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
4 Replies
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,
LydiaNo 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.
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
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.
