Welcome to the LimeSurvey Community Forum

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

RemoteControl 2 API and Power BI

  • SifraWestendorp
  • SifraWestendorp's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago - 3 years 6 months ago #205670 by SifraWestendorp
RemoteControl 2 API and Power BI was created by SifraWestendorp
Good day all,

I require your help on the following. We use Power BI to visualize the results of surveys. For this we use an API (export_responses) that until recently worked very well for us. Now, all of a sudden my report broke down with the following message: "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."

We use Json to open the file with.

The credentials still work and haven't changed. The surveys themselves haven't changed. What could be causing this issue? Unfortunately, I am not a very technical person and I was not involved in setting this report up, that colleague has left our company.

Your help is much appreciated!

Best,
Sifra
Last edit: 3 years 6 months ago by SifraWestendorp.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 months ago #205678 by DenisChenu
Replied by DenisChenu on topic RemoteControl 2 API and Power BI
html, maybe a html error …

Didn't know since you give no information …

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.
  • SifraWestendorp
  • SifraWestendorp's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 6 months ago #205680 by SifraWestendorp
Replied by SifraWestendorp on topic RemoteControl 2 API and Power BI
Thanks for your reply! What information would you require to get a better understanding of my issue?

Thanks,
Sifra
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 months ago #205692 by tpartner
Replied by tpartner on topic RemoteControl 2 API and Power BI
My guess is that the export_responses() call is returning an error (HTML), not the base64 encoded data. I think you will need to access your API file directly to see what the error is.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 6 months ago #205706 by DenisChenu
Replied by DenisChenu on topic RemoteControl 2 API and Power BI
LimeSurvey version and build number
Did export work good in GUI
Can you access to API public url
Can you trace the HTML produced
What did you update on server.
etc …

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.
  • gabrieljenik
  • gabrieljenik's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
3 years 6 months ago #205736 by gabrieljenik
Replied by gabrieljenik on topic RemoteControl 2 API and Power BI
Hi,

We have developed a plugin for connecting with PowerBi:
www.encuesta.biz/en/producto/limesurvey-...n-powerbi-connector/
You can take a look at it if you want.

Can you please provide the LS version you are using?
This could be part of a bug.

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.

Lime-years ahead

Online-surveys for every purse and purpose