monday.com boards into Power BI and your Azure data warehouse
Project data from Monday.com
Yres retrieves data from monday.com through the monday.com GraphQL API, at the fixed address https://api.monday.com/v2. It signs in with a personal API v2 token that is sent as an Authorization header on every call. The token has the same permissions as the user who created it, so that user determines which boards Yres can read. The retrieved data lands in an Azure SQL database in your own Azure tenant, where it can be combined with your other sources for Power BI.
At a glance
- Connection
- The monday.com GraphQL API at https://api.monday.com/v2. This is the fixed API address, not the address of your own account
- Sign-in
- Personal API v2 token, sent as an Authorization header
- What Yres can see
- Exactly what the user behind the token can see: the token inherits that user's board permissions
- Validity
- A token can have an expiry date. In Yres you can record an expiry date for the credentials on the source
- Where it runs
- On the Azure Data Factory cloud integration runtime; monday.com is a publicly reachable service, so no self-hosted runtime is needed
- Where the token is kept
- In the Key Vault of your own Azure environment; the connection fetches it from there on every call
What you arrange yourself
- 1Choose the account the token will be created under: it needs read access to every board you want to expose.
- 2Log in to monday.com with that account, click the avatar in the top right → Developers → My Access Tokens and copy the personal API v2 token. Admins can also find it under Administration → Connections → Personal API token.
- 3Add the Monday source in Yres, leave the address at https://api.monday.com/v2 and paste the token.
- 4Record any expiry date of the token on the source, so you replace it in time.
When you need this — and when you don't
A standalone connector is enough if…
If you only want to follow the progress of projects and tasks, the views inside monday.com are enough and you do not need a data warehouse.
Yres adds value if…
Yres earns its place once the work in monday.com has to sit next to figures from other systems, such as logged hours, invoicing or staffing, or when you want to see what a board looked like on an earlier date. monday.com shows the state of today; the data warehouse keeps earlier versions of changed rows.
Frequently asked questions: Monday.com
Which monday.com boards can Yres read?
Every board the user behind the API token has read access to, and no others. If a board is missing, first check that account's permissions in monday.com.
Which address do I enter: that of my monday.com account?
No. You enter the fixed API address, https://api.monday.com/v2. The form only accepts addresses that start with https://api.monday.com/; the address of your own account environment does not work.
Does Yres use the GraphQL API or a REST API of monday.com?
The GraphQL API. Technically the connection runs over a REST connection in Azure Data Factory that sends the token as a header, but the queries Yres puts to monday.com are GraphQL queries on the v2 address.
What should I arrange around the personal token?
The token belongs to one user. So create it under an account deliberately chosen for this purpose with sufficient read access, and keep an eye on any expiry date. If you replace the token, you update it on the source in Yres.
Full technical description in the knowledge base →·Last reviewed:
Data warehouse automation that runs in your own Azure
Built for organisations on Azure and Power BI. Yres connects your sources, keeps the history and promotes changes in a controlled way, without manual work.