I’m posting this for the Monday.com customers who are using Power BI to connect to Monday.com.
I attended a webinar last week that discussed the changes to the Monday.com API that will be released in October of this year. The syntax used in the query from the code found here → Loading GraphQL data (monday.com API v2) into PowerBI · GitHub will need to be updated.
I forked a copy of the code created by @dipro and updated the M language code to work with the new API.
If you want to continue to use the 2023-07 version of the API you will need to modify your current Power BI Query to include the API-Version you wish to use.
Currently the first bit of your code might look like this:
let
Source = Web.Contents(“https://api.monday.com/”,
[
RelativePath=“v2”,
Headers=[
#“Method”=“POST”,
#“Content-Type”=“application/json”,
#“Authorization”=“<your_personal_token_here>”
],
The API migration document says that the 2023-07 version of the API will still be the default once October 2023 hits but if you want to be certain of the version of the API being used you can modify your code to look like this:
let
Source = Web.Contents(“https://api.monday.com/”,
[
RelativePath=“v2”,
Headers=[
#“Method”=“POST”,
#“Content-Type”=“application/json”,
#“Authorization”=“<your_personal_token_here>”,
#“API-Version” = “2023-10”
],
From the API Migration document the timelines are as follows:
Timeline
July 2023 – version 2023-10 is announced and available for preview
October 2023 – version 2023-10 becomes stable (no new changes), but 2023-07 will still be used by default
January 2024 – version 2023-07 is no longer supported
So you will need to update and test all of your Power BI queries before January or it looks like you Power BI queries will break, causing your reports to no longer work.
Hoping this saves some of you some time.