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