Is it Possible to Export Monday.com Activity Logs (via API or a different method) to Power BI?

[Redraidas10]

Has anyone attempted to develop an API or devise a method for exporting Monday.com activity logs in bulk for subsequent importation into Power BI for analysis? If so, I would greatly appreciate it if you could share the approach you took to achieve this. Thank you!

[Anonymous · Accepted solution]

Hi  @Redraidas10 ,

According to my research and previous tests, the custom M language in the Power query editor of Power BI desktop can theoretically connect to any rest API by using the "Web.Contens" function, but the prerequisite is that we need to get the request header, body and authentication method (token) required for the API to run successfully. Contens" function in the Power query desktop editor can theoretically connect to any rest API, but only if we can get the request header, body and authentication method (token) needed for the API to run successfully, if you have an example of the corresponding API, you can follow this official document's writing style to connect to it in your custom M language.

Web.Contents - PowerQuery M | Microsoft Learn

Here's another blog on Power BI desktop connecting to the official rest API, which you can check out together

Power BI REST API: Step-by-step Guide to Use It | Coupler.io Blog

Best Regards,

Liu Yang

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