Versions Compared

Version Old Version 6 New Version Current
Changes made by

Viktoriia Yevhrafova

Viktoriia Yevhrafova

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 is organized into separate tables.

The following table names have been updated as follows:

  1. “duration“ to “time-tracking“

  2. “multiple-person“ to “people“

If you already have a Power BI report, attempting a refresh might result in errors.

Image Modified

Please follow these steps to resolve the issue.

  1. Click on “Transform data” in Power BI Desktop.

  1. In the new window click on “Refresh Preview” → “Refresh All”.

  1. In the left sidebar, choose the table with the error indicated by an exclamation sign, and then click the "Edit Settings" button.

  1. In the pop-up Navigation window, choose a new table and click OK.

The mentioned changes will modify the Source, and you can also change the table's name if needed by right-clicking on it.

This step is optional and will not impact further refreshes.

Column

types

Types renaming

Column Names consist of ‘Namethe ‘Name', ‘Type’ ‘Type’, and 'Index’ ID’ of the column.

Due to Types rename renaming a lot of fields changed their names to new ones.

Image Added

Next Types were renamed to:

  1. “color“ to “status“

Image Added

  1. “boolean“ to “checkbox“

  2. “multiple-person“ to “people“

  3. “timerange“ to “timeline“

  4. “duration“ to “time_tracking“

  5. “numeric“ to “numbers“

  6. “long-text“ to “long_text“

  7. “timezone“ to “world_clock“

Example: If you previously had a column with name “Seller

  1. “boolean“ to “checkbox“

  2. “multiple-person“ to “people“

  3. “timerange“ to “timeline“

  4. “duration“ to “time_tracking“

  5. “numeric“ to “numbers“

  6. “long-text“ to “long_text“

  7. “timezone“ to “world_clock“

E.g.: If you had a column previously named "Seller (multiple-person_seller)

” - a new name for the same column will be “Seller

," it will now be renamed to "Seller (people_seller)

”Type “tag“ was renamed to “tags” and currently is not avilable for getting

."

Old version

Image AddedImage Added

  1. The type "tag" has been renamed to "tags," and it is no longer available for obtaining the tags list as a string.

Now information

  1. Information about tags is

available

  1. now accessible only through an additional table called "tag,"

with

  1. which includes links to "Tags

" (Column of type “tags“ was removed from table “Items“).

  1. ."
    As a result, the "tags" column type has been removed from the "Items" table.

Image Added

Complexity points and limits for requested information size

Changes in complexity points and limits for requested information size might cause could potentially result in a decrease in export speed, possibly slowing it down (by up to 2x 2 times).

Exported data type changes

Type The type of fields which contain Identificators containing identifiers (ID) was has been changed from INT64 to String within in the export.