Howard Bouk hmbouk
hmbouk
/ .Monday-paginated-board-PBI-query
Last active
March 4, 2024 12:54
Monday-paginated-board-PBI-query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| The following files are the three functions and a query that can be used to retrieve data from a Monday.com board | |
| using the new 2023-10 API and Cursor-based pagination. |
hmbouk
/ monday-GraphQL-PowerBI.m
Last active
March 19, 2024 13:14
— forked from yuhgto/outdated-monday-GraphQL-PowerBI.m
Loading GraphQL data (monday.com API v2) into PowerBI
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Playing around with a PowerBI query to pull data from monday.com into PowerBI | |
| // This can come in handy when building PowerBI reports that utilize GraphQL endpoints for loading data. | |
| let | |
| Source = Web.Contents("https://api.monday.com/", | |
| [ | |
| RelativePath="v2", | |
| Headers=[ | |
| #"Method"="POST", | |
| #"Content-Type"="application/json", |