An analyst is building a Tableau data source. They have connected to a SQL Server database and now need to incorporate related data from a separate Excel file. How can they create a single data source that uses both connections?
Create a union between the SQL Server table and the data in the Excel file.
On the Data Source page, use the 'Add' button next to 'Connections' to select the Excel file.
Convert the initial SQL Server connection to an extract before adding the Excel file.
Create two separate data sources and combine them on a worksheet using data blending.
The correct method to create a single Tableau data source with data from different databases, like SQL Server and Excel, is to add a second connection on the Data Source page. This creates a multi-connection data source, allowing tables from both sources to be combined using relationships or joins. Data blending is different, as it combines data from separate data sources at the worksheet level, not within a single data source. A union is used to append rows of data from tables with similar column structures. Converting to an extract affects performance and data portability but is not a prerequisite for adding a new connection.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a multi-connection data source in Tableau?
Open an interactive chat with Bash
How are relationships different from joins in Tableau?
Open an interactive chat with Bash
When would you use data blending instead of relationships or joins?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .