Connect api management to Power BI

Question

I have azure api management endpoints using oauth 2.0 and gets data from cosmos DB, now I need to create power BI reports out of this data. Is is possible to connect API endpoint directly to power BI and generate reports?

Answer 1

Vikas Tiwari Thanks for posting your question in Microsoft Q&A. I assume you have defined APIs in API Management to get Cosmos DB data and would like to generate Power BI reports with that data. You can create a custom Power Platform connector to an API in API Management and then calls the API (managed by APIM) from Power Platform to get the data for generating reports. Check out doc: Export APIs from Azure API Management to the Power Platform for more info on this.

Note: Currently, Power BI is not supported in Q&A forums (the supported products are listed here) and please reach out to dedicated forum https://community.powerbi.com/t5/Get-Help-with-Power-BI/ct-p/PBI_GetHelp for any assistance such as accessing Power BI APIs, managing connectors or how to generate reports etc. in related to Azure Power BI. The product group for Power Apps can assist you with your questions.

If you have any questions in API Management, feel free to add a comment and would be happy to answer them. I hope this helps with your questions.

---

If you found the answer to your question helpful, please take a moment to mark it as "Yes" for others to benefit from your experience. Or simply add a comment tagging me and would be happy to answer your questions.

Answer 2

Hi Vikas,

You could just use Power BI to connect directly to Cosmos DB:

Visualize Azure Cosmos DB data using Power BI

https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/powerbi-visualize

---

If this is helpful please accept answer.