Before you begin, create a workspace and complete the onboarding.

​
Local driver or Power BI?

There are two alternative methods to connect Excel to your data.
Way to connectPros 👍🏼Cons 👎🏼
Local DriverDon’t require licens for Power BI.Need ODBC-driver. More complex setup.
Power BIMore stable. Native within Microsoft tools. Refresh data from Excel for web.Require licenses for Power BI.
We encourage you to explore the possibilities with Google Sheets, as an alternative to Microsoft Excel. Sheets is a more modern and fully cloud based tool. We will be happy to help you get started.

​
Local driver

​
Overview

These are the steps you take to access your data from Excel.
1

Prepare a Service Account

This will confirm that you should have access to your sensitive data.
2

Install Driver

The ODBC driver will create a connection between Excel and Enhanza.
3

Connect from Excel

Now can you can easily connect directly from within Excel.

​
Install Driver

  1. Download and install ODBC drivers for Bigquery.
    Make sure to select the correct version (32-bit or 64-bit) based on the version of your Microsoft Office. What version of Office am I using?
  2. Open the Windows software “ODBC Data Sources”
  3. Go to tab “System DNS”, click “Add” and add these details:
    • Data Source Name: Enhanza
    • Description: app.enhanza.com
    • oAuth Mechanism: Select “Service Account”
    • Service Authentication: The service account email that you generate above.
    • Click Browse… and locate the .json file that you created above.
    • Catalog (Project): Select “enhanza”
    • Dataset: Select any. Doesn’t matter which.
    • Click Test… If success, click “OK” on all open dialogue windows.

​
Connect from Excel

  1. Open Excel. Go to Data > Get Data > Other data sources > ODBC
  2. Select Enhanza and click OK
    At this stage, you can also choose to write a custom query to get the exact data you need. Enhanza Support team can you help you with that if needed.
  3. In the next dialogue window (if appears), select tab Default or Custom and click Connect.
  4. Now you have all you connected data source in Enhanza available.

​
Power BI

Connecting Excel to existing datasets in Power BI is a smooth sailing.
  1. Connect Power BI to Enhanza
  2. Publish the local .pbix file to Power BI services
  3. Connect Excel to Power BI