- Posts: 11
- Thank you received: 10
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
LimeSurvey PowerBI integration
- adamzammit
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
4 years 1 month ago #194330
by adamzammit
LimeSurvey PowerBI integration was created by adamzammit
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
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
The following user(s) said Thank You: DenisChenu, tpartner, christianlangkamp
The topic has been locked.
- gabrieljenik
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 272
- Thank you received: 45
4 years 1 month ago #194392
by gabrieljenik
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .
Replied by gabrieljenik on topic LimeSurvey PowerBI integration
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
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
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .
The topic has been locked.
- christianlangkamp
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
4 years 1 month ago #194437
by christianlangkamp
Replied by christianlangkamp on topic LimeSurvey PowerBI integration
Does this work with the hosted version ?
The topic has been locked.
- adamzammit
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 11
- Thank you received: 10
4 years 1 month ago #194442
by adamzammit
Replied by adamzammit on topic LimeSurvey PowerBI integration
I don't think so - you can use it on the Desktop version then publish the results to the web though
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
4 years 1 month ago #194443
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic LimeSurvey PowerBI integration
Think yes, API can be activayed on hosted ?
You just need API ? Right ?
You just need API ? Right ?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
4 years 1 month ago #194473
by jelo
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.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic LimeSurvey PowerBI integration
Hosted version of LimeSurvey was meant.adamzammit wrote: I don't think so - you can use it on the Desktop version then publish the results to the web though
Not hosted version of PowerBI.
The pythonscript is using the RemoteAPI of LimeSurvey.
Code:
#Limesurvey details - change these to match your Survey remotecontrolurl = "http://localhost/limesurvey/index.php/admin/remotecontrol" limeuser = "admin" limepasswd = "password" surveyid = "1"
So the answer christianlangkamp's question is YES.
You can use this script to connect to the hosted version of LimeSurvey.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: DenisChenu, adamzammit
The topic has been locked.