cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ClintonSaunders Frequent Visitor
Frequent Visitor

On-premise data gateway not available for all datasets

Hi,

 

Since the beginning of this week I am having a problem with the On-Premise Gateways picking up the datasource linked in a Dataset. When looking at the Dataset refresh schedule setup page, under the Gateway's section, none of the Gateways are available for selection:

Screenshots.png

 

In "Manage Gateways", the Gataeways are connected succssfully and the relevant data sources are confugured and connected to successfully:

Screenshots.png

I did a test where I setup a Personal Gateway on one  of the Data sources, to see if that worked, and I was able to get it to work with that... but not with the Business Gateway. This is a problem as I have multiple gateways, all of which are experiencing this issue.

 

Like I said, everything was workign fine last week, and suddenly this week it is not, and nothing has changed on my side.

 

Hope this gets reslved asap.

 

Clinton

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
ClintonSaunders Frequent Visitor
Frequent Visitor

Re: On-premise data gateway not available for all datasets

Hi.... I found the problem! In the datasets, there was also a connection to an OData source where the DNS name had changed and not updated in the Dataset, and as such the name could not be resolved. This was stopping the association to the Gateway Datasource for some or other reason. When I sorted out the OData name issue, then the Gateway Datasource was selectable again....

 

Clinton

Moderator v-qiuyu-msft
Moderator

Re: On-premise data gateway not available for all datasets

Hi @ClintonSaunders,

 

Thanks for your update. As the issue is gone now, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: On-premise data gateway not available for all datasets

Hi @ClintonSaunders,

 

 

Would you please update the on-premises data gateway to the latest version? 

 

Please find on-premises data gateway log files, and check if any error or exception logged. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Vicky_Song Established Member
Established Member

Re: On-premise data gateway not available for all datasets - Status changed to: Needs Info

 
ClintonSaunders Frequent Visitor
Frequent Visitor

Re: On-premise data gateway not available for all datasets

Hi there.... I have already downloaded the new Gateway Version after I discovered that the Gateway was not working properly, but got the same result. I looked at the Gateway logs on the On Premise computer, and there were no errors logged there.

 

Just to clarify what I have said above.... when looking at the Gateway connection in the "Manage Gateways" section of the PBI Service, there is a successfull connection for ALL of my gateways (even the ones that I have not yet updated to the latest version). Datasources matching those in the relevant Datasets are configured and they all connect successfully.

 

The problem is trying to connect the Datasets to the Datasources in the Gateway connections - I am unable to do this because tey do not get associated successfully to the datasets (see images in my post above). There appears to be no problem with the On-Premise Gateway to Serviice connection....

 

JUst some additional information that may help. I am connection to two types of Data Sources using the Gateways - one is a network folder, and the other is an ODBC (Firebird) database. Each of these Datasource types are on separate computers running their own Gateways. I would like to re-iterate that this was working fine last week for a few months now... and suddenly went "off" this week.

 

I trust that this clarifies? 

ClintonSaunders Frequent Visitor
Frequent Visitor

Re: On-premise data gateway not available for all datasets

Hi.... I found the problem! In the datasets, there was also a connection to an OData source where the DNS name had changed and not updated in the Dataset, and as such the name could not be resolved. This was stopping the association to the Gateway Datasource for some or other reason. When I sorted out the OData name issue, then the Gateway Datasource was selectable again....

 

Clinton

Moderator v-qiuyu-msft
Moderator

Re: On-premise data gateway not available for all datasets

Hi @ClintonSaunders,

 

Thanks for your update. As the issue is gone now, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.