Connect api management to Power BI

Vikas Tiwari 766 Reputation points
2023-04-08T14:43:45.6833333+00:00

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?

Azure API Management
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
1,805 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MuthuKumaranMurugaachari-MSFT 22,236 Reputation points
    2023-04-11T00:06:02.2833333+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

  2. Dillon Silzer 54,831 Reputation points
    2023-04-09T03:32:13.47+00:00

    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.

    0 comments No comments