You can use Microsoft Power BI Desktop to query data sources with Dremio.
In Power BI Desktop, click Get data. The pins in this image show two locations for this option.
In the Get Data window, search on “Dremio”, select Dremio Software, and click Connect.
In the Dremio Software window, specify the hostname or IP address of your Dremio cluster, and select DirectQuery. Then, click OK.
Specify the username and password for Power BI to use when connecting to your Dremio cluster.
At this point, you can either continue by selecting a dataset or click Cancel. The next time you launch Power BI Desktop, you can select the connection by clicking Home in the menu bar and Recent sources in the ribbon bar.
You can use the
export.bi.hostname support key to change the default hostname of the SQL endpoint for generating PBIDS files. The
property is available from Dremio version 13.0.0.
To know how to set the
export.bi.hostname support key, see Support Keys.