Power BI to extract data from Monday.com automatially

[LijunChen]

Hello, Dear Community Members, 

I am planning to create a power BI dashbaord displaying some information of the active employees in our firm. We keep a updated list of all active employees in Monday.com. But I don't think Power BI offer any easy connecter to Monday.com data tables. Monday.com recommends using a paid 3rd party service Alpha Servce. Has anybody use this? 

I am also thinking to use MS 360 active directory data in Power BI. The AD tables have employee region, email, state, reporting manager, etc. I have use it in Sharepoint lists quite a bit. What is the  best way to read the AD table into Power BI? 

Thank you very much for your advice. 

Lijun   

[CoderZen08]

Hi @LijunChen you could use windsor.ai's Monday connector. It's still in beta but I've used it and has all metrics I need in my case. Works fine even for a beta connector so just to let you know 

[amitchandak]

@LijunChen , refer if these can help in case of active directory
https://learn.microsoft.com/en-us/power-query/connectors/active-directory
https://www.dbi-services.com/blog/power-bi-active-directory-data-integration/

For Active employee refer

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU