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

We reached the data gateway, but the gateway can't access the on-premises data source.

Until recently I have not had an error of this type. For some inexplicable reason, at least to me, I cannot connect to the on-premise data source. I have tried uninstalling and reinstalling the data gateway and then re-establishing the connection to the gateway using the recovery key. This error ONLY occurs when I try to connect to my Analysis Services data sources. This does NOT occur when connecting to my SQL Server data sources. I have ensured that my user names have been mapped correctly. I have defined the roles in the tabular model, yet I still cannot get past this error. I am currently dead in the water!

1 ACCEPTED SOLUTION

Accepted Solutions
TomLenzmeier Frequent Visitor
Frequent Visitor

Re: We reached the data gateway, but the gateway can't access the on-premises data source.

Amy,

 

Thanks for your response. I've followed all of the suggestions you provided. Oddly enough, I installed a new gateway on a different server and connecting to my SSAS data connection works perfectly. 

5 REPLIES 5
Community Support Team
Community Support Team

Re: We reached the data gateway, but the gateway can't access the on-premises data source.

Hi @TomLenzmeier ,

 

Could you please show us the error information?

 

You can refer to the link:https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas, pay attention to the steps configuring gateway for SSAS.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

TomLenzmeier Frequent Visitor
Frequent Visitor

Re: We reached the data gateway, but the gateway can't access the on-premises data source.

Here is the error message. Also, thanks for the link and I did find this previously and have followed the steps outlined in it. 

Screenshot_1.png

 

Community Support Team
Community Support Team

Re: We reached the data gateway, but the gateway can't access the on-premises data source.

Hi @TomLenzmeier ,

 

Please check if your Server name and Database name is correct, and make sure the Username and Password is your local gateway installed computer domain_name\user_name and password, for example if the computer account is abc@def.com, then the domain_name\user_name is def\abc, the password is the password longlining in to the computer.

 

1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In addition, you need to set Map user name, replace your Power BI Desktop account with the your local gateway installed computer domain_name\user_name. you can refer to the link: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names.

 

Or try to upgrade the gateway to the latest version.

 

Also, you may resolve the issue via the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#data-sources .

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

TomLenzmeier Frequent Visitor
Frequent Visitor

Re: We reached the data gateway, but the gateway can't access the on-premises data source.

Amy,

 

Thanks for your response. I've followed all of the suggestions you provided. Oddly enough, I installed a new gateway on a different server and connecting to my SSAS data connection works perfectly. 

Community Support Team
Community Support Team

Re: We reached the data gateway, but the gateway can't access the on-premises data source.

Hi @TomLenzmeier ,

 

Glad to hear the issue is resolved,  maybe the solution is just to upgrade the gateway, you can accept this post as solution, that way, other community members would benefit from the solution.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 311 members 3,472 guests
Please welcome our newest community members: