I found your query is quite similar to the given link here https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports?show=26876#q26876
Have a look and let me know it worked or not!!
To connect my web API with Power BI Reports, you can go through the following below:
Go to Home > Edit Queries > Advance Editor. Here is some Power Query code to query issue a GET request to an API endpoint.
Source = Json.Document(Web.Contents("http://mywebapi"))
Go to Home > Edit Queries > ...READ MORE
Use ADAL.js that will give you an ...READ MORE
You can view the Azure Active Directory ...READ MORE
If you are a tenant admin, and ...READ MORE
Having knowledge about these topics is a must.
Power ...READ MORE
format the KPI by selecting the paint ...READ MORE
To undo your last action or last few actions, press ...READ MORE
It can be achieved depending on the result you ...READ MORE
Toggling is an action that is achieved ...READ MORE
In the menu bar, choose the Selection ...READ MORE
Already have an account? Sign in.