I am looking for a way of creating dashboards on power BI by using the data in Monday.com.
I need to extract 3 monday.com boards (within my company space)and that information needs to be available for me to create dashboards in power BI.
Could you please let me know if there is a way to connect Monday.com to power BI? The data need to be in a space where it can be near real time.
- If there is a direct way to connect to Monday to power BI, let me know.
- If direct connection is not possible, How could I automatically extract an excel file of the Monday boards(For a given frequency: e.g: once a day at 1400) and place it in a location so I can read the files on power BI.
Your help on this is highly appreciated.