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 …
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.