Dataflow: one or more data sources currently used have not been registered on this gateway

[Marc1979]

Hi everybody,

I am trying to get a dataflow load data from a data source which is provided via on premise gateway.

I have registered the data source in power bi service with a succesfull connection test.

When I create a new dataflow querying a single table from this data source via the on premise gateway I get the error below:

I am sure the server name and database name in power query match the ones configured in the data source of the gateway.

For testing purposes I created a Power BI file querying the same data source.

After publishing to Power BI service I connect the dataset to the on premise gateway.

Everything works fine and I can refresh the dataset.

Is this a bug in dataflows or anyone knows what could be the reason of the error?

Thanks!

Marc

[v-shex-msft]

Hi @Marc1979 ,

Can you confirm you are choose the correct gateway or you have permission to access that gateway? Can you please share more detail information to help us clarify this scenario?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[Marc1979 · Accepted solution]

I found out the issue, you can't use multiple gateways within the same dataflow.

I created a separate dataflow and then I was able to choose a different gateway for the entity.

Kind regards,

marc