Access API data from

[PowerBINewUser]

I have an API that uses Bearer access token to retrive data.
First I have to use login API to fetch the token
Then using that token I can query the data
How can I make it work in PowerBI.

[aj1973]

@PowerBINewUser 

Are you trying to use Power BI REST API?

[PowerBINewUser]

Thanks Amine. No I am using the Power BI Desktop not the Power BI API.

I have a VMware Horizon API from where I want to fetch the data.

[aj1973]

I see,

The bad news is that there is no native connector in Power BI desktop that can help you fetch the data from VMware Horizon. Maybe developping an M code in Power Query to use the API can do it but I would doubt that it could work in the service to refresh data !!!

Though the good news is that you can use Powershell to connect to the VMware, Fetch and export data in CSV or JSON format, store them files in a server or a local machine and then use those files in Power BI desktop to build your report. Note, if the storage is going to be in a local machine then you will need to install Power bi Gateway On-Prem in order to refresh data in the service.

Check this out also, it might help

Solved: Get VMs from VCenter via API - Microsoft Fabric Community