Dataset doesn't see Maps to Directory from Gateway

[Anonymous]

My team has setup a gateway cluster that has several connections to different data points.  I have access to at least 2 of these.  

However, when I load my dataset to Power BI (cloud) and try to select a gateway to enable auto refresh I will select my gateway, and then click on the button that looks like a play button and I only see 1 connection to map to.  The one I need is not showing up.  

Do we need to do something to get this to show up?  I'm listed as a user in both connection areas in the Gateway cluster.  

[v-lili6-msft]

hi, @Anonymous 

Please check this as document:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#i-dont-see-the-on-premises-data-gateway-present-when-configuring-scheduled-refresh

and also check the gateway cluster setting as the documents:

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

Best Regards,

Lin

[Anonymous · Accepted solution]

Thanks @v-lili6-msft  but I figured out the issue.  And it was quite simple.

The ID I was using had access to 2 DB's.  My connection in the dataset was pointing to the other dataset but since I had my queries as fully qualified it wasn't erroring out on my laptop only when I uploaded it.  So I went to Edit Queries >Data Source Settings

Changed the source and changed the DB to point to the correct DB.

Saved and it allowed me to select the correct gateway when I uploaded it.

[Anonymous]

hi @v-lili6-msft  ,

Thank you for the articles. I have a question though on some things I'm not 100% clear on.

1) If I select the "Allow users cloud data sources..." what does that actually do?

2) After I have added the datasource I want to connect to my Gateway Cluster I go to the picture below to modify point it to my new cluster. However, instead of "new data source" it just has 1 of the sources from my cluster, not the one I need. However, I noticed the DB (in this it says "AdventureWorks") isn't the DB I want either. Is there a way to change this to point to my DB/Data Source? Keep in mind I have a secondary datasource because only a few Apps can access this source in the cluster.

Or should I just modify my dataset to point to the existing source and call it a day?