# Accessing dremio from Excel Powerpivot

**URL:** <https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285>\
**Category:** Uncategorized\
**Created:** [June 14, 2022, 5:06pm UTC](https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285 "2022-06-14T17:06:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cklar](https://avatars.discourse-cdn.com/v4/letter/c/b3f665/32.png) [@cklar](https://community.dremio.com/u/cklar)\
**Post date:** [June 14, 2022, 5:06pm UTC](https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285/1 "2022-06-14T17:06:14Z")

</div>

Hi,

Trying to read some data from Dremio into Excel Powerpivot.

Server=XX.XX.XX.XX;Port=31010;Provider=MSDASQL.1;User ID=XX;DSN=Dremio Connector; PWD=XX;AUTHENTICATIONTYPE=Basic Authentication;CONNECTIONTYPE=Direct;HOST=XX

I’m able to create a successful test connection. And I can even list the different tables. But I can’t execute any queries (syntax error) and even selecting an entire table does not work (“Object reference not set to an instance of an object.”)

I’m able to import tables into Tableau without issues.

Any help would be appreciated.

---

<div class="post-metadata">

**Author:** ![cklar](https://avatars.discourse-cdn.com/v4/letter/c/b3f665/32.png) [@cklar](https://community.dremio.com/u/cklar)\
**Post date:** [June 23, 2022, 6:32pm UTC](https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285/2 "2022-06-23T18:32:23Z")

</div>

Hi - just pushing this to the top.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [July 2, 2022, 7:41am UTC](https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285/3 "2022-07-02T07:41:30Z")

</div>

@cklar Dremio is designed to query excel data in Dremio not the other way round

---

<div class="post-metadata">

**Author:** ![cklar](https://avatars.discourse-cdn.com/v4/letter/c/b3f665/32.png) [@cklar](https://community.dremio.com/u/cklar)\
**Post date:** [July 2, 2022, 12:56pm UTC](https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285/4 "2022-07-02T12:56:57Z")

</div>

The usage of Excel Powerpivot as a client of Dremio is referenced on your website.

[https://docs.dremio.com/software/client-applications/microsoft-excel/microsoft-excel-powerpivot/](https://docs.dremio.com/software/client-applications/microsoft-excel/microsoft-excel-powerpivot/)

I’m just running into the mentioned errors in my first post.

---

<div class="post-metadata">

**Author:** ![jduong](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jduong/32/21_2.png) [@jduong](https://community.dremio.com/u/jduong)\
**Post date:** [July 2, 2022, 1:26pm UTC](https://community.dremio.com/t/accessing-dremio-from-excel-powerpivot/9285/5 "2022-07-02T13:26:45Z")

</div>

@cklar Dremio has released a new ODBC driver and Power Pivot is supported. It is available here:

> **[ODBC Driver for Apache Arrow Flight SQL | Dremio](https://www.dremio.com/drivers/odbc/)**
>
> Download ODBC Driver for Apache Arrow Flight SQL for Dremio.

The syntax error usually is related to not setting the Quoting property to BRACKET. By default the Dremio driver treats double-quotes as the quoting character but Power Pivot uses square brackets. Please configure your Dremio DSN to add Quoting=BRACKET to the Advanced Properties.

Note that in the updated driver, encryption is enabled by default and can be toggled in the Advanced Properties tab.