Skip to main content

Microsoft Dataverse

Connection Type

Alteryx Tool. The latest version is available from the Alteryx Marketplace.

Type of Support

Read & Write

Release Notes

November 6, 2025

Dataverse Version 1.2.3

What's New

  • We enabled high precision data to let users utilize nanosecond precision for the DateTime and Time fields, which use millisecond precision by default. The precision is adjusted automatically.

  • We updated the logic for issuing new refresh tokens.

Fixed Issues

Fixed

Dataverse Version 1.2.3

ID

Description

TPM-5000

Write operations other than overwrite fail with an error.

TPM-4823

The Dataverse Input tool is missing the Modified On filters.

TPM-4819

The Dataverse tools fail to fetch data with the error “Unique identifier column not found.”

TPM-4783

Developer Tools in Designer expose secret values in JSON.

TPM-4644

Update and Upsert operations fail with the error “Unique identifier column not found.”

TPM-2616

The Dataverse tool doesn't populate column metadata.

Known Issues

Known

Dataverse Version 1.2.3

ID

Description

TPM-4397

The Dataverse Output tool fails with an AttributeError (“'str' object has no attribute 'get'”) when inserting multiple records.

Cancelled Issues

Cancelled

Dataverse Version 1.2.3

ID

Description

TPM-3666

TPM-3377

A saved workflow doesn’t run successfully on another machine.

TPM-2772

Input fields don’t trim leading or trailing whitespaces.

Previous Version

Version

Description

v1.2.2

  • Compatible with Designer 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Requires AMP engine.

  • Fixed issue where the update and upsert operations failed with the “Unique identifier column not found” error. (TPM-4420)

  • Fixed issue where Dataverse Output failed when data contained decimal values or apostrophes. (TPM-4245, TPM-4053)

  • Fixed issue where the Dataverse tools requested unneeded permissions for API apps. The Dataverse tools now request only the required permissions. (TPM-3986)

  • Fixed issue where the Dataverse tools couldn’t connect without a DCM connection. (TPM-3723, TPM-3203)

  • Fixed issue where the Dataverse tools ignored proxy settings. (TPM-3355)

  • Fixed issue where Dataverse Input didn’t pass all the records to other tools. (TPM-3210, TPM-3201)

v1.2.1

  • Compatible with Designer 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Requires AMP engine.

  • Fixed issue where the update and upsert operations failed with the “Unique identifier column not found” error. (TPM-4420)

  • Fixed issue where Dataverse Output failed when data contained decimal values or apostrophes. (TPM-4245, TPM-4053)

  • Fixed issue where the Dataverse tools requested unneeded permissions for API apps. The Dataverse tools now request only the required permissions. (TPM-3986)

  • Fixed issue where the Dataverse tools couldn’t connect without a DCM connection. (TPM-3723, TPM-3203)

  • Fixed issue where the Dataverse tools ignored proxy settings. (TPM-3355)

  • Fixed issue where Dataverse Input didn’t pass all the records to other tools. (TPM-3210, TPM-3201)

v1.2.0

  • Compatible with Alteryx Designer and Server version 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Requires AMP engine.

  • Added support for DCM.DCM - Designer

  • FIPS capable.

  • Fixed issue where Dataverse Output returned errors when writing number datatypes into Dataverse. (TPM-2265)

  • Fixed issue where Insert and Update operation didn’t work on rows with foreign key columns. (TPM-2343)

  • Fixed issue where Dataverse Output returned an error when writing medium sized dash (U+2013). (TPM-2342)

  • Fixed issue where Dataverse Output returned an error when writing Null values. (TPM-2266)

  • Fixed issue where Overwrite action in Dataverse Output only affected first 5000 records. (TPM-2557)

v1.1.2

  • Compatible with Alteryx Designer and Server version 2023.2 and later.

  • Minor update to maintain compatibility with Designer and Server 2023.2.

v1.1.0

  • Compatible with Alteryx Designer version 2021.3.4 to 2023.1.

  • Authentication occurs using user's browser instead of embedded CEF in Designer to comply with modern security policies like Conditional Access.

v1.0.1

  • Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.

v1.0.0

  • Initial release.

  • Compatible with Alteryx Designer version 2021.3 and later.

  • Built-in multitenant Azure App with an option to use custom Azure App (including single-tenant app or Service Principal).

  • Read data from selected table using Saved Queries, Custom OData queries, or Manual filters.

  • Insert, Overwrite, Upsert, or Update selected tables.

  • Proxy support.

  • Requires Office 365 with license for Dataverse.

Alteryx Tools Used to Connect

Dataverse Icon Dataverse Input Tool

Dataverse Icon Dataverse Output Tool

Custom Microsoft Azure API Application Setup

To set up a custom API application for this tool, go to our guide.

Limitations

Sign In Expiration

Standard sign-in (Sign in via Internet Browser) expires after 24 hours so it's not suitable for scheduling workflows. For scheduling, select Use Service Principal after you select the Provide authentication information option. Service Principal requires a custom API Application.

In this section: