Hi @kaiolima
Yes, agree with @baoussounda , you will need to use the powerQuery code to make it possible.
You need to do as below
- Retrieve the access token by giving your using client credentials using the PAT.
- Then you need to make another POST API call to call the search API. Personally, i use the report extraction APIs because with search API, we need to add the pagination logic (which is possible) but powerBI does give the issues when the identities exceeds more than 10K. So in that case, it is better to use report extraction API.
In addition to that there was also a very nice demo presented during 2024 developer days. You can check out the amazing session
I hope this helps. If you need more information, please let me know, happy to help.
Thank You.
Regards
Vikas.