Microsoft Excel PowerPivot

Prerequisites

Dremio Excel PowerPivot integration requires:

  • Microsoft Excel 2013 with PowerPivot Add-on
  • Install Dremio Connector. Architecture needs to match Excel's: 32 or 64-bit.

Updating Dremio DSN Configuration for Excel PowerPivot

  1. Run the ODBC Data Sources (64-bit or 32-bit) Windows application.

  2. Open the System DSN tab, select 'Dremio Connector,' and hit the Configure button.

  3. Add the following to the end of the Advanced Properties in Dremio Connector DSN:

    quoting=BRACKET;supportFullyQualifiedProjects=true
    

Connecting to a Dremio Cluster

  1. Open Excel, go to PowerPivot tab and click Manage. Then select From Other Source under Get External Data.

  2. Choose Others (OLEDB/ODBC)

  3. Enter the following connectin string including DSN, Dremio username and password:

    Provider=MSDASQL.1;User ID=dremio;DSN=Dremio Connector; PWD=123456
    

  4. Select tables to import or write custom SQL query.

  5. Your Dremio dataset is now ready to use in Excel.


results matching ""

    No results matching ""