cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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

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:

 

 

screenshot.JPG

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors