Logic Monitor Integration with PowerBI

[TejasMagar]

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.

[Anonymous]

Hi,@TejasMagar .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.

[TejasMagar]

Hi @Anonymous ,

Thank you for response.

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

errmsgstatus

Authentication failed

1401

It was showing above message.

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

Thank you.

[Anonymous · Accepted solution]

Hi,@TejasMagar .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.