Monday.com to Power BI Adapter

This is an adapter that retrieves data from the Monday API v2 and converts to a Power BI friendly format while keeping the API key hidden

API Token (v2) Board (ID or URL)

Formatted columns Adapt specific columns data to be easier to work with in Power BI.

Subitems Multiply the lines by each subitem and adds the subitems columns.

Hide the API Token Instead of exposing the API token, which gives full access to your account, generate a key that only works for the specified board.

Decimal Separator using Commas Instead of separating decimals with a dot, uses a comma. Example: 14.5 becomes 14,5.

Developed by Guilherme Chaguri. The code is be available on GitHub

I've also created a Power Query to directly connect to the Monday.com API, it's harder to setup, doesn't secure the API key, formats columns or include subitems but avoids a third-party service.