I’ve improved @dipro script to automatically explode Monday columns in a table: Power BI Monday.com Query - Power Query M · GitHub
I’ve also created a NodeJS script and pushed it to Heroku to make it easier to import and format Monday items: GitHub - Guichaguri/MondayPowerBIAdapter: Adapts a Monday board to Power BI
It also generates a token that only gives access to a single board, so you don’t have to expose your API Key in your report. The key is stored in a database, but if you want you can take the code and host yourself.