Power BI - Survey Monkey Language information

[Luzbarrientos]

I have a report from Survey Monkey, the extraction of the information is working well, but when trying to add the Language the issue, is that, to add the language it is necessary to use a dynamic query, and the schedule refresh couldn't be done.

Someone had experience with Survey Monkey and language information? because I need to schedule the daily refresh.

Thank you!

[Luzbarrientos · Accepted solution]

This is the information from Survey Monkey if someone is searching about the same topic. 

Currently, with our Power BI integration, no language column will be extracted into Power BI when the data of a multilingual survey is extracted. This is a current limitation of our Power BI integration, I'm afraid.

I understand that this isn't ideal so sorry for that. I've passed the feedback from this case to our integrations team for our Power BI integration. As this is a limitation of the Power BI integration, there isn't a way to have the languages data be included when data is extracted using the Power BI integration. But our integrations team is looking at potentially adding a language column for our Power BI integration when data is extracted. If and when this comes in a future update, we'll let you know.

Then, as for now it is not possible to use it with the connector.

[Luzbarrientos · Accepted solution]

This is the information from Survey Monkey if someone is searching about the same topic. 

Currently, with our Power BI integration, no language column will be extracted into Power BI when the data of a multilingual survey is extracted. This is a current limitation of our Power BI integration, I'm afraid.

I understand that this isn't ideal so sorry for that. I've passed the feedback from this case to our integrations team for our Power BI integration. As this is a limitation of the Power BI integration, there isn't a way to have the languages data be included when data is extracted using the Power BI integration. But our integrations team is looking at potentially adding a language column for our Power BI integration when data is extracted. If and when this comes in a future update, we'll let you know.

Then, as for now it is not possible to use it with the connector.

[Luzbarrientos · Accepted solution]

Good news for the ones that had the same issue as me, recently I received this email from the Survey Monkey team: there was a limitation with our Power BI integration where no language column will be included in the extract into Power BI when the response data of a multilingual survey is extracted. We've released an update to our Power BI integration to address this limitation. Now, when you extract response data via the Power BI integration, there will be a language column. So if your survey is multilingual, the language for each response will now be exported via our Power BI integration. 
This update was released in March so it does require you to update your Power BI Desktop to the March 2023 version or later for you to see this update.