Issue with Power BI Dataflows Gen 1 Using Dremio Software Connector

1

Description:
We are using a self-deployed Dremio OSS instance to feed Power BI datasets, semantic models, and dataflows via the Dremio Software Connector.

Screenshot at Nov 28 18-32-01
Screenshot at Nov 28 18-32-011050×565 41.2 KB

Context:

  • Dremio OSS powers Power BI datasets and semantic models.
  • All existing Power BI dataflows and datasets refresh successfully without requiring a Microsoft Data Gateway.
  • The Dremio connection status in Power BI’s “Manage Connections and Gateways” is marked as Online.
    Screenshot at Nov 28 18-22-38
    Screenshot at Nov 28 18-22-381229×202 22.5 KB

Problem:
Since mid-October, I have been unable to create new Dataflows Gen 1 without using a Microsoft Data Gateway. However, existing dataflows and datasets continue to function as expected without the need for a gateway.

Questions:

  1. Have there been any recent changes to the Dremio Software Connector that now require a Data Gateway for Dataflows Gen 1?
  2. Is it possible to access older versions of the Dremio OSS documentation for reference, I would like to check what the documentation said about data gateways in previous versions such as Dremio 24.2.X?

I appreciate any insights or guidance on resolving this issue.

2

@balaji.ramaswamy sorry to bother you, but I do have some urgency on this matter. :pray:

3

@cesar-santos Seems like Powerbi is not allowing you to create new Dataflows Gen 1 without using a gateway and this is in the PowerBI layer, have you checked with powerbi if anything has changed, meanwhile i am checking on the dremio side

4

Hi @balaji.ramaswamy ! thank you for your response.

I don’t remember this document mentioning the requirement of using a Data Gateway:

Regards.

5

@cesar-santos That is exactly hat I am also trying to say. seems like this is a new requirement from PowerBI. Is the server or you are trying from Desktop?

6

@balaji.ramaswamy we actually seeing the error when trying to create a new data flow from Power BI cloud.

7

@cesar-santos My bad ! Did not realize it was from Dremio cloud. Have you followed this?

8

@balaji.ramaswamy, just to reinforce, we are using the Dremio Software connector on Power BI, is it possible to check an older version of this same documents you are sharing?
To be more specific I would like to check older versions from this page: Creating Dataflows by Using the Dremio Software Connector | Dremio Documentation

9

@cesar-santos Checking on this and will get back to you

1 Like