Skip to main content

Troubleshooting Connections to Dremio Cloud from Microsoft Power BI

Power BI Service update (June 2022)​

Problem​

Microsoft Power BI Service (June 2022 - Client version: 2206.1.11664-train) now contains the ability to directly connect to Dremio Cloud without a gateway. See the following actions to turn off a gateway to connect new or already published reports.

Solution: Reports created using Power BI Desktop and published to Power BI Service​

  1. In Power BI Service, open the Data hub tab. Click the vertical ellipsis next to the dataset and select Settings.

  2. Expand the Data source credentials section and click Edit credentials.

  3. Select an authentication method.

  4. Set the Privacy level setting for this data source.

  5. Click Sign in.

    If the connection is successful, the report will run.

Solution: Reports created using Power BI Desktop and published to Power BI Service​

  1. In Power BI Service, open the Data hub tab. Click the vertical ellipsis next to the dataset and select Settings.

  2. Expand the Gateway connection section and toggle On-premises or VNet data gateway off.

  3. Expand the Data source credentials section and click Edit credentials.

  4. Select an authentication method.

  5. Set the Privacy level setting for this data source.

  6. Click Sign in.

    If the connection is successful, the report will run.

Mismatch of parameters between Power BI Desktop and Power BI Gateway​

Problem​

As new versions of the Dremio Power BI connectors are released, this will change some of the parameters you can enter. When this occurs, there could be errors reported in Power BI Service such as:

(1110) Unable to determine the data source.(1110) Gateway or datasources not reachable.

Typically this will occur if you have generated a report (pbix) with a newer connector and you tried to open it with an older connector.

Solution​

It is important that both Power BI Desktop and Power BI Gateway use the same connector Dremio.mez file version. You can ensure this by installing Power BI Desktop and Power BI Gateway, which have the same installation date (example: September 2021).

The Power BI connector is contained in a Dremio.mez file, which is not the same as the desktop and gateway versions.

note

It is recommended to use the latest connector version as this offers the best backward compatibility.

Power BI Desktop Installation​

The Power BI Desktop installation should not have the connector Dremio.mez file installed locally. Instead, it should use the Certified Connector that comes with Power BI Desktop.

To ensure there is no local version on your Windows computer:

  1. Open a File Explorer and navigate to C:\Users\<your user>\Documents\Power BI Desktop\Custom Connectors.

  2. If this folder exists and the file Dremio.mez exists in that folder, then delete the file.

  3. If Power BI Desktop is open, then close it. When you reopen Desktop, it will find the correct Dremio connector.

Power BI Gateway Installation​

The Power BI Gateway installation should not have the connector Dremio.mez file installed locally. Instead, it should use the Certified Connector that comes with Power BI Gateway.

To ensure there is no local version on your Windows computer:

  1. Open Power BI Gateway and then select Connectors from the left menu.

  2. Use a File Explorer and navigate to C:\Users<your user>\Documents\Power BI Desktop\Custom Connectors.

  3. If this folder exists and the file Dremio.mez exists in that folder, then delete the file.

  4. Restart Power BI Gateway.

Uncertified Connector message​

Problem​

When the Power BI Desktop is opened and the Dremio connector is selected in Get Data, the following pop-up message appears:

This error occurs because there is a Power BI connector installed locally.

note

We are moving away from having connectors installed locally. Instead, you should use the certified connectors that are available as part of the desktop or gateway installations.

Solution​

Check to see if you have a Dremio.mez file in the C:\Users\{Your Username}\Documents\Power BI Desktop\Custom Connectors folder. If so, you should remove it.