Loading

Unable to Set Relationship for Multiple Tables When Using Microsoft Access

Publiseringsdato: Apr 22, 2025
Beskrivelse

The error below occurs ​after using a Relationship with Access data in Tableau Desktop:

Unable to complete action
This data source uses a connection that doesn't support multiple logical tables. Add a single logical table, open it, and then add the table in the physical layer of the data source.
For more information on logical and physical tables, see
https://www.tableau.com/en-us/app/om-physical-logical?build=20231.23.0310.1044&edition=pro&lang=en-us&platform=windows&version=2023.1


 

Cause

The ability to use the Relationship option with Access data is not currently possible.
Løsning
As a workaround, instead of creating relationships, add the second table in the physical layer of the data source. Steps are detailed below:

1. Drag the first table to the canvas.
2. Double-click on the table just dragged to the canvas (this will open the physical layer of the data source).
3. Drag the second table to the canvas.

Vote on the Tableau Community to Allow Relationships to work with data that doesn't support LODs
 
Flere ressurser
For a full list of data sources that cannot be related, please review the Online Help [Data that can't be related].
Knowledge-artikkelnummer

001498189

 
Laster
Salesforce Help | Article