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.
Thank you for the response.
I am based in Australia, and IT is not our core function so we do not have developers. Is there any plugins that will enable me to automate the extraction of an excel sheet with the board information?
If you want please feel free to connect to our monday.com team on monday@jtscloud.com and we’d be happy to learn the details of your project and put a plan together to achieve a great result for you!
I have this setup for Airtable to PowerBi and since their both Open API’s, it should work the same way. Message me and I can assist you in setting it up.
The dashboards are great but PowerBi can dive into more information very quickly. I have dashboards set up for a general overview but when we discuss specific projects for each of our customers(aka lots of data), the PowerBi ability to be interactive is incredible.
With monday.com being a WorkOS we connect PowerBI all the time, it’s a common request. It’s all about the use case and what is needing to be achieved. monday.com supports that perfectly!
We have a solution for you!!!
With Power BI Connector for monday.com by DOIT-BI, without any technical knowledge, without much effort and in minutes, you can export big data from monday.com to Power BI and build informative business reports.
Since you are looking for expert help to connect Power BI with monday com, I would suggest you get in touch with monday.com consultants and seek end-to-end consultation regarding the same. When partnering with monday experts, you may ask them if there is a way to integrate Power BI with monday com where the data gets updated in real-time.
This question was asked 3.5 years ago!? Anyway if @sjayawardana is still wondering “…How could I automatically extract an excel file of the Monday boards.” this can be done in Excel using some VBA and the Monday.com API. It’s tricky to set up but once you get the API syntax correct you can re-purpose you code for unlimited access to your Monday board data - with no costs involved.