Due to numerous breaking changes introduced in the new API version "2023-10," we are implementing several crucial updates on our end for Monday.com data export. The changes will be implemented on October 1st, 2023 to guarantee a smooth transition with no disruptions.
These changes involve various adjustments, including modifications to column type names, changes in query complexity points, and revisions to data size limits.
Please take a moment to review the upcoming changes, as they may impact existing Power BI reports.
Tables rename
During the export process, you receive data of various types organized into separate tables.
The following table names have been updated as follows:
“duration“ to “time-tracking“
“multiple-person“ to “people“
If you already have a Power BI report, attempting a refresh might result in errors.
You can fix it by following next steps:
Open the “Transform data“
...
Please follow these steps to resolve the issue.
Click on “Transform data” in Power BI Desktop.
Select Table with error in left sidebar and click “Edit Setting“ button
In pop-up window choose new resource
Optionally you can rename Table by clicking right mouse button on a chosen Table
Column types renaming
Column Names consist of ‘Name', ‘Type’ and 'Index’ of column.
Due to Types rename a lot of fields changed their names to new ones
Next Types were renamed to:
“color“ to “status“
“boolean“ to “checkbox“
“multiple-person“ to “people“
“timerange“ to “timeline“
“duration“ to “time_tracking“
“numeric“ to “numbers“
“long-text“ to “long_text“
“timezone“ to “world_clock“
Example: If you previously had a column with name “Seller (multiple-person_seller)” - a new name for the same column will be “Seller (people_seller)”
Type “tag“ was renamed to “tags” and currently is not avilable for getting tags list as a string. Now information about tags is available only through additional table "tag" with links to "Tags" (Column of type “tags“ was removed from table “Items“).
Complexity points and limits for requested information size
Changes in complexity points and limits for requested information size might cause export speed slowing down (up to 2x times).
Exported data type changes
Type of fields which contain Identificators (ID) was changed from INT64 to String within export.