Skip to main content

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.