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

html, maybe a html error …

Didn't know since you give no information …

Thanks for your reply! What information would you require to get a better understanding of my issue?

Thanks,
Sifra

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.

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 …

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.