Hi everyone,

One of our customers wanted labelled responses available for reporting in PowerBI but connecting directly to the LimeSurvey database via the MySQL connector only gave the unlabelled data from the survey and tokens tables. Also the column names are not very readable for reporting.

In response I have written this Python script which you can run from PowerBI desktop that will import fully labelled data using the LimeSurvey API and the LimeSurvey Python connector (from here: github.com/ESchae/limesurveyrc2api )

Here is the link to the script:

github.com/adamzammit/limesurvey-powerbi-python

Get in touch if you have any difficulty running it.

Adam

Nice!

I have also been working on PowerBI integration.

I have a plugin that allows to connect a survey to PowerBI.
The data is refreshed on PowerBI regularly, so is good for watching progress.

Thanks

Does this work with the hosted version ?

I don't think so - you can use it on the Desktop version then publish the results to the web though

Think yes, API can be activayed on hosted ?
You just need API ? Right ?

adamzammit wrote: I don't think so - you can use it on the Desktop version then publish the results to the web though

Hosted version of LimeSurvey was meant.
Not hosted version of PowerBI.

The pythonscript is using the RemoteAPI of LimeSurvey.
So the answer christianlangkamp's question is YES.
You can use this script to connect to the hosted version of LimeSurvey.