We are currently looking at automating some of our weekly / monthly business reporting in PowerBI. I've read through the Developers Guide, HQ PowerBI Connection Guide and REST API Documentation and have a fairly good basis for connecting HQ with PowerBI. I'm familiar with DBs and Excel, however I still have a few questions about how to go about retrieving the data we require.
Currently I have all our users, projects, companies and reportings in PowerBI, however I am unable to determine how we can pull our CustomFields, such as our internal teams ("Resource Groups") each user is assigned to.
I have had a look into the AllCustomFields REST request, however, it doesn't appear to shed any light on my issue as I can't determine how users are assigned to these groups or vice versa.
Any help would be much appreciated.