I do al follows:
You need to change the sharing settings of your form for this to work ( caution with sensitive data)
Then I use:
https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv
to obtains the lables in the default languague…
of if the lang you need is called "::English (en)"
https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv?lang=English (en)
then query with Power query or PowerBi
