Forum Discussion
Is it Possible to Export Monday.com Activity Logs (via API or a different method) to Power BI?
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!
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.
1 Reply
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.