fleurvoice

Hi everyone. I am trying to set up an API between Go 4 Schools and PBI, but it isn't working. We have got the API key, but we are unsure where exactly we need to link the URL to. We have been trying with the "O Data" feed. Is there a better way to link to GO? When we add the key etc. we get the error "An API key value wasn't specified". We have tried all different ways like adding the API key as the username, chaging the URL path, using the key in the URL path but we can't seem to get anywhere with it. We have also used https://api.go4schools.com/customer/v1/academic-years/{academicYear}/students -H "Authorization: Bearer {ApiKey}" but that hasn't worked either. Would really appreciate some pointers, please! Thanks in advance

Thanks. I'll double check to make sure. I have also noticed that the error occurs here: Maybe I'm assuming that the issue is with CR when it's not? Sorry, I'm just trying to troubleshoot in as many ways as possible.

Thanks for your reply, Martin. I have run the bat file manually, which has now caused an error in Power Query. No errors came up in the bat file though

Hi! I have been having some issues with Command Reporter not pulling out all of the data fields from my reports in SIMS, which then leads to errors in PBI/Power Query. I'm assuming that CR is the issue because when I go into SIMS and run the report manually, then go into PBI and refresh, the error disappears. I have seen this issue before with other dashboards I manage, and I was wondering if anyone knew why this would be happening, how I fix it, and/or if there is a better and more efficient way to link SIMS and PBI so that the reports run daily? Thanks in advance!