Pulling data into excel Power Query using API URL

@sector, have you gone through our support article (it should solve your issue):