Breaking changes with new API version '2023-10'

Tables rename

During the export process, 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.

Please follow these steps to resolve the issue.

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

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

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

4. 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 renaming

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

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

Next Types were renamed to:

1. “color“ to “status“

2. “boolean“ to “checkbox“

3. “multiple-person“ to “people“

4. “timerange“ to “timeline“

5. “duration“ to “time_tracking“

6. “numeric“ to “numbers“

7. “long-text“ to “long_text“

8. “timezone“ to “world_clock“

E.g.: If you had a column previously named "Seller (multiple-person_seller)," it will now be renamed to "Seller (people_seller)."

9. The type "tag" has been renamed to "tags," and it is no longer available for obtaining the tags list as a string. Information about tags is now accessible only through an additional table called "tag," which includes links to "Tags."
   As a result, the "tags" column type has been removed from the "Items" table.