Anyone here using PowerBI or power query in excel? I’m trying to integrate data from Commcare using web query, I used to do that using the advanced editor in the query, and copy the link from “Excel dashboard integration” in Commcare, It was working fine, but now Microsoft doesn’t support the basic authentication, I generated an API key and was hoping to solve the authentication problem, but still it didn’t work, even after I copied the key in its slot (the photo attached).
I Tried som ready M codes with the API name in the code but didn’t work
Does anyone know how to solve this? where to put the API name and key?
any kind of help would be very much appreciated