# PowerBI Direct Query

**URL:** <https://community.dremio.com/t/powerbi-direct-query/6500>\
**Category:** Uncategorized\
**Created:** [October 29, 2020, 4:19pm UTC](https://community.dremio.com/t/powerbi-direct-query/6500 "2020-10-29T16:19:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![YEN](https://avatars.discourse-cdn.com/v4/letter/y/50afbb/32.png) [@YEN](https://community.dremio.com/u/YEN)\
**Post date:** [October 29, 2020, 4:19pm UTC](https://community.dremio.com/t/powerbi-direct-query/6500/1 "2020-10-29T16:19:15Z")

</div>

Hello everyone!

I am still trying to get a working Direct Query with PowerBI. I hoped that the latest release of Dremio & Power BI could help, but it’s doesn’t seem.

- Dremio: 4.9 Community
- dremio-connector-odbc-1.5.1.1000-win64
- Power BI Desktop for Report Server (October 2020)

I only open PBI Desktop:  
Get data -\> More -\> ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/e/e7fae6fa9080ff552419efb24b4bddf1d89b586b.png)

Select DirectQuery (seems good!)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/4/4252d63cfb2f89a3963567d6b33bac06b1d241c1.png)

Select my data then load:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/617857fda2b3161ba95c30bd5a7511d994ef68fe.png)

There’s the result:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a0d413a09172b18fc4cdfa8e053516c156a1676a.png)

Impossible to have Direct Query at all?  
I am not even trying to publish it to PBI Report Server yet …

Any ideas?

Thank you.

---

<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:** [October 29, 2020, 4:27pm UTC](https://community.dremio.com/t/powerbi-direct-query/6500/2 "2020-10-29T16:27:51Z")

</div>

Hi @YEN,

I haven’t seen this warning before but did see a reference to it here:

> **[Database change leads to Switching to Import Mode](https://community.powerbi.com/t5/Desktop/Database-change-leads-to-Switching-to-Import-Mode/td-p/18284)**
>
> We have a set of reports that feed from an Azure SQL database, which I'll refer to as the "test" database.  The reports are using DirectQuery.  We'd like to instead have these same reports read from a different database, a production Azure...

Do you have perhaps have another data source in your report aside from the new Dremio data source you are creating?

---

<div class="post-metadata">

**Author:** ![YEN](https://avatars.discourse-cdn.com/v4/letter/y/50afbb/32.png) [@YEN](https://community.dremio.com/u/YEN)\
**Post date:** [October 29, 2020, 4:45pm UTC](https://community.dremio.com/t/powerbi-direct-query/6500/3 "2020-10-29T16:45:21Z")

</div>

Thank you jduong!  
No, I tried to add a SQL in DQ, then disabled it (thinking than maybe Dremio will work in DQ as well, but no, it directly change in Imported.  
So seems impossible to have a Direct Query between Dremio and Power BI …

---

<div class="post-metadata">

**Author:** ![Henry\_From\_Mars](https://avatars.discourse-cdn.com/v4/letter/h/0ea827/32.png) [@Henry\_From\_Mars](https://community.dremio.com/u/Henry_From_Mars)\
**Post date:** [March 1, 2021, 3:25pm UTC](https://community.dremio.com/t/powerbi-direct-query/6500/4 "2021-03-01T15:25:25Z")

</div>

This is untrue.

I just noticed the Dremio options under ODBC connection, but I have been using the Dremio connector driver that’s separately installed from Dremio’s website. It seems the ODBC doesn’t allow direct query, and is based on my window’s ODBC setting?

Eitherway, it’s been a frustrating endeavor to properly connect and maintain encryption.