Hi,

I have been trying to pull data direct from the database into an Excel and apply filter in M etc etc...

I am really struggling writing a query that uses the question title, instead of the SGQA identifier.

In table lime_questions, I can CONCAT the QID, PARENT_QID, SID and GID to get the SGQA, however for Array (Texts) there is also the SCALE_ID which makes it difficult to get the SGQA code.

Does anyone have a query for this?

I never use direct SQL since there are API
api.limesurvey.org/classes/remotecontrol...hod_export_responses

Then when we update our system : you don't need to update yours …

Hi Denis,

Thank you, the API is useful but not fit to purpose at the moment.

I am running reports from Limesurvey into Excel Power Queries and Power BI direct.

So how do you connect directly from powerquery to Limesurvey ? Are you on the hosted version or do you have your own instance ?

Sorry, what do you mean by that?

We host a version of Limesurvey on www.limesurvey.Contoso.com .

To get reports, I connect directly to the SQL database either from Excel or Power BI.

Was trying to have a look Contoso.com jumps directly to the main Microsoft website …

So my question is, I don't want to get into hosting myself, but it would be really sweet to be able to connect to the Limesurvey data like you would connect to an SQL Database.

christianlangkamp wrote: So my question is, I don't want to get into hosting myself, but it would be really sweet to be able to connect to the Limesurvey data like you would connect to an SQL Database.

Contoso.com is used in Microsoft Docs as a placeholder for your own domain.

rbernhardthki can connect directly to the database cause it's not a SaaS hosting via LimeSurvey.org.

It makes so sense to post in every thread here. No customers of LimeSurvey.org Hosting can access the database directly via SQL. The only interface is the RemoteControl API.

Focus on one thread:
www.limesurvey.org/forum/can-i-do-this-w...esurvey-sql-database