Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Logic Monitor Integration with PowerBI

Hi All,

How to connect with MS Power BI desktop using Logic Monitor Application Program Interface (API) and Bearer Token?

We are able to connect Logic Monitor with Python Script but please help in above query.

Interesting Links
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,Anonymous .Thank you for your reply.
    Using Python is indeed better than connecting using the web as I described, as using Python offers much more functionality.
    It is great to see that you were able to get your issue resolved and working fine.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

    Best Regards,

    Carson Jian,

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,Anonymous .I am glad to help you.

    Although I am not very good at Logic Monitor integration with Power BI Desktop, I would like to provide some suggestions to give you some help.
    About Logic Monitor integration with Power BI Desktop is roughly divided into the following processes.
    1. Get Bearer Token
    2. Configure the web data source about Logic Monitor in power BI Desktop.
    Select “Get Data” > “Web”, enter the URL of Logic Monitor API, and add HTTP request header in Advanced Options, including Bearer Token for authentication.

    3. Use Power Query to process the data, including loading, transforming and cleansing.

    4. Using data to create visual production reports

    Here are some related documents and articles I found, hope it helps you.
    URL:

    Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
    Using LogicMonitor's REST API | LogicMonitor
    Power BI REST API Integration Guide (enterprisedna.co)
    Using LogicMonitor's REST API as a Power BI Source - Part 2 | LogicMonitor - 11177

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous ,

      Thank you for response.

      I tried this solution for integration between Logic Monitor and PowerBI but It was not working.

      errmsgstatus

      Authentication failed1401

      It was showing above message.

      So, I tried using python script and it is working.

       

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi,Anonymous .Thank you for your reply.
        Using Python is indeed better than connecting using the web as I described, as using Python offers much more functionality.
        It is great to see that you were able to get your issue resolved and working fine.

        I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

        Best Regards,

        Carson Jian,

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.