Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

LimeSurvey PowerBI integration

  • adamzammit
  • adamzammit's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
5 years 2 months 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
The following user(s) said Thank You: DenisChenu, tpartner, christianlangkamp
The topic has been locked.
  • gabrieljenik
  • gabrieljenik's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
5 years 2 months ago #194392 by gabrieljenik
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
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 .

[img
The topic has been locked.
  • christianlangkamp
  • christianlangkamp's Avatar
  • Offline
  • Junior Member
  • Junior Member
More
5 years 2 months 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
  • adamzammit's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
5 years 2 months 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
  • DenisChenu's Avatar
  • Away
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
5 years 2 months ago #194443 by DenisChenu
Replied by DenisChenu on topic LimeSurvey PowerBI integration
Think yes, API can be activayed on hosted ?
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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
5 years 2 months ago #194473 by jelo
Replied by jelo on topic LimeSurvey PowerBI integration

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.
Code:
#Limesurvey details - change these to match your Survey
remotecontrolurl = "https://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.
Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source