DEV Community

Cover image for Tableau Migration: Export and Connect Data in Bold BI
Bold BI by Syncfusion
Bold BI by Syncfusion

Posted on

Tableau Migration: Export and Connect Data in Bold BI

TL;DR: Tableau's per-viewer licensing and embedding costs push many teams to migrate to Bold BI®. The underlying data usually moves over cleanly as a CSV or Excel export, but calculated fields, LOD expressions, and dashboard formatting don't transfer automatically and need to be rebuilt. This guide covers what to check before migrating, the export/connect steps, and how to validate the result.

Introduction

Tableau migrations often start with one practical question: Can we reuse what has already been built? In some cases, data sources and underlying queries can be transferred with minimal changes. Whether reuse is possible depends on factors such as data source compatibility, calculated field complexity, dashboard structure, and the export method used during migration. The extracted data can be imported into Bold BI®, connected to the appropriate source, and validated before rebuilding dashboards.

If your Tableau environment relies heavily on calculated fields, custom parameters, advanced visual formatting, or Tableau-specific interactivity, you will likely need to recreate some of that logic within Bold BI. In this guide, we'll cover why teams make this switch, what to review in your Tableau workbooks before you start, and the step-by-step process for exporting, connecting, and rebuilding your dashboard in Bold BI.

Why migrate from Tableau to Bold BI?

Organizations often consider moving from Tableau to Bold BI for a mix of licensing, embedding, and deployment reasons. Some of the more common ones include:

  • Licensing costs that scale with every viewer. Tableau's per-user pricing can add up as more people need access to dashboards.
  • Embedding requirements. Teams building dashboards into their own product sometimes find Tableau's embedding options require additional licensing and setup work.
  • White-labeling needs. Matching dashboards to a company's own branding is not always straightforward in Tableau.
  • Deployment flexibility. Bold BI supports a range of deployment options, including Windows, Linux, Docker, Kubernetes, and managed cloud environments.

Teams that make this switch typically see licensing costs stop scaling with headcount, and product teams shipping embedded analytics cut their time-to-launch from months of internal build to days of configuration.

For a fuller side-by-side breakdown of licensing, embedding, and deployment differences, see our Bold BI vs. Tableau comparison.

Before you start: What to check in your Tableau workbooks

Before exporting anything from Tableau, it's worth stepping back and deciding what should be migrated in the first place. A successful BI migration is not just about moving dashboards from one platform to another. It's also an opportunity to evaluate which dashboards still create value, which can be simplified, and which are no longer needed.

Many organizations discover that a significant portion of their analytics assets are rarely viewed, duplicate existing dashboards, or support processes that have since changed. Auditing your Tableau environment before migration can help reduce effort and ensure that time is spent rebuilding the dashboards that matter most.

When evaluating dashboards for migration, consider three areas:

  • Usage frequency. Prioritize dashboards that are actively used by business teams. Understanding who uses a dashboard, how often it's accessed, and whether other dashboards depend on it can help you avoid rebuilding assets that no longer provide business value.
  • Calculation complexity. Dashboards that rely heavily on calculated fields, Level of Detail (LOD) expressions, table calculations, or custom logic need extra rebuild time. Tableau's documentation notes that exporting data may exclude some table calculations and LOD expressions, so these should be reviewed and recreated separately rather than assumed to transfer automatically.
  • Stakeholder criticality. Some dashboards support executive analytics, regulatory requirements, or key business decisions. Even if they're not viewed frequently, their importance may justify prioritizing them during migration.

Once you've identified the dashboards worth migrating, a short technical review can help surface issues before they become surprises later in the process. This approach turns the migration process into a deliberate modernization effort rather than a simple platform transfer, helping teams focus resources on the dashboards that deliver the greatest impact.

What can be migrated from Tableau to Bold BI?

Not every part of a Tableau dashboard transfers the same way. The table below summarizes what typically carries over and what usually needs validation or rework.

Tableau Asset Potential Reusability Validation Required
Underlying data (exported as CSV or Excel) Generally reusable once connected Yes
Calculated fields and LOD expressions Usually need to be recreated Yes
Dashboard visuals and layout Usually require rebuilding Yes
Filters and interactivity May require reconfiguration Yes
Security and sharing settings Require review and reconfiguration Yes

Because raw data is often the most reusable part of a Tableau workbook, exporting it correctly is a reasonable place to start.

How to migrate data from Tableau to Bold BI

Exporting data from Tableau to Bold BI generally follows the same core pattern: extract the underlying data, connect it to the new platform, and rebuild the visuals and calculations on top of it. Say you're a sales operations analyst, and your team's sales dashboard, built in Tableau to track revenue and order volume by country, needs to move to Bold BI before your next licensing renewal. Here's what that migration looks like in practice, from export to rebuild. This example uses a CSV export, since that's the most common starting point, with notes on the Excel path where it differs.

Step 1: Open the worksheet in Tableau

Open the Tableau workbook containing the worksheet you want to migrate, in this case your sales data by country, and go to the Data Source.

Click Data Source Click Data Source

Step 2: Export the data to CSV

Click Data, select Export Data to CSV, and choose the table you want to export. If your sales dashboard pulls from multiple tables, such as orders and customer countries, export each one separately to keep the files organized in Bold BI.

Export Data to CSV Export Data to CSV

Step 3: Save the exported file

Save the CSV file somewhere you can access it easily, such as a shared drive your team already uses. If your workflow depends on Excel instead, Tableau also supports exporting a crosstab directly. Tableau's documentation has a full breakdown of export options.

Save the exported file Save the exported file

Step 4: Open Bold BI and start a new data source

In Bold BI, go to Data Sources, then select New Data Source and choose Create Data Source from the dropdown to open the connection panel.

Click Data Sources Click Data Sources

Click New Data Source Click New Data Source

Step 5: Select the file type

In the Add Data Source tab, choose Files from the category drop-down list. Then, under Service Connectors, select the CSV tile and click Select.

If your export is an Excel file, select the Excel connector instead, which follows a slightly different flow covered in Bold BI's Excel connector documentation.

Add data source Select the category as files

Select CSV Choose CSV from the available file types

Step 6: Upload the file

Upload your exported CSV file. If it includes a header row, such as your column names for country, order date, and revenue, enable Consider the first row as header so those carry over correctly. If your file uses tabs or semicolons instead of commas, set the matching separator during this step.

Connect to CSV Upload the file

Step 7: Preview and connect

Click Preview and Connect, then choose the schema you want to use from the preview dialog. This is a good moment to confirm your country and revenue fields came through as expected before moving on.

Preview the data Preview the data

Step 8: Rebuild and preview the dashboard

Use Bold BI's dashboard designer to rebuild your visuals, and recreate any calculated fields or LOD expressions from your original workbook in the formula builder. Once your dashboard is rebuilt, the sales team can track total sales and order counts, compare revenue by country, analyze which customer channels drive the most sales, and see which companies and products are performing best, all in one place instead of switching between separate Tableau worksheets.

Sales Analysis Dashboard Sales Analysis Dashboard

Best practices for Tableau migration

Validation matters more than most teams expect during a migration like this. A few practices that help:

  • Start small. Begin with one or two dashboards rather than migrating everything at once. This helps you test the process before committing more time.
  • Validate early. Compare row counts, totals, and filter behavior between the original Tableau dashboard and the rebuilt Bold BI version before considering the migration complete.
  • Review dependencies. Double-check calculated fields, LOD expressions, and any live data source connections that may need reconfiguration.
  • Maintain documentation. Track which dashboards have been migrated, what was changed, and any issues found along the way.
  • Involve the people who use the dashboard. Ask the team members who rely on a dashboard daily to review the rebuilt version before you retire the original.

A short overlap period, where both the Tableau and Bold BI versions stay available, gives everyone a chance to confirm the new dashboard works as expected before retiring the old one.

Ready to migrate from Tableau to Bold BI?

Migrating from Tableau is more than moving data to a new platform. It's an opportunity to build a scalable analytics environment that supports embedded BI, simplifies governance, and reduces long-term licensing and infrastructure costs.

In most cases, you can export your existing datasets and connect them to Bold BI quickly. The dashboards, visualizations, and calculated fields that need to be recreated are where the real effort lives, and that effort scales with the complexity of your Tableau implementation.

To help teams accelerate adoption, Bold BI provides a complete onboarding experience, including guided product walkthroughs, documentation, video tutorials, technical blogs, and dedicated customer support.

Whether you're building your first dashboard or migrating your analytics platform, Bold BI® helps you get started quickly.

Ready to get started?

Related Resources 

Frequently asked questions

1. Can Tableau workbooks be imported into Bold BI directly?
Not directly. Bold BI connects to exported CSV or Excel files, or to your original data source if it is a live database or cloud application.
2. Do calculated fields transfer automatically from Tableau?
No. Calculated fields and LOD expressions generally need to be recreated using Bold BI’s formula builder, which is why reviewing them during the assessment stage is worthwhile.
3. What file formats does Bold BI support for migrated data?
Bold BI supports CSV, Excel, JSON, and XML files, along with 140+ direct connectors for databases, cloud services, and APIs.
4. How long does a typical Tableau to Bold BI migration take?
It depends on the number of dashboards and calculated fields involved. A single dashboard with a handful of visuals can often be exported, connected, and rebuilt within a day.
5. Should all dashboards be migrated at once?
Not necessarily. Migrating one or two dashboards first, validating the results, and then moving the rest in batches tends to reduce the risk of surprises.
6. What should be validated after a Tableau dashboard is rebuilt in Bold BI?
Row counts, totals, filter behaviour, and calculated field results are worth checking against the original Tableau version before retiring it.

Top comments (0)