Fail to refresh dashboards using onpremise data gateway to connect to Analysis Services

[felipe_regis]

Hi everyone.

We are trying to refresh data on some power bi dashs using a on-premises data gateway.

It follows what we are trying to do (1), steps completed, issues and test results (2):

1. We would like to enable scheduled refresh on published dashboards on Power BI web using an onpremise data gateway. Data source is an onpremise server running Analysis Services.

2. We followed mostly the documentation "Install an on-premises data gateway " and "Manage your data source - Analysis Services" step by step.

2.1. We installed the standard data gateway on an on-premises server and configured the gateway using a service account with admin server priviledges as requested. After all, gateway status is ready.

2.2. Dashs on Desktop report is fine and correctly loaded. When we pusblish it look at the Power BI web, data can't be loaded and message to contact gateway admin is showed as below.

2.3. Then we checked with our network team and double checked firewall rules to allow outbound connections and also to allow traffic between data gateway server and analysis services server source. Telnet test is OK on the gateway server.

2.4. We also followed the docs "Adjust communication settings for the on-premises data gateway" and ran port tests and the log results were all OK besides we got the following error mesage below: 

communication tests:

Power BI web error provided when clicking on the message. It's in portugese but it says to contact support and provide the following details:

2.5. When configuring gateway settings on manage gateways option in Power BI web, a tested credential (user/password) was used to create the data source connection and provide refresh details. Configuration completed and saved, gateway connected and ready but dashs still can't load data when refreshed. 

Does anybody can help with this issue?

Thanks in advance,

Felipe Regis

[felipe_regis · Accepted solution]

tnks, @ccollins!

We made it. There were a few configurations missing on the vm to access service user in AD. DNS server was wrong and as a consequence, gateway wasn't able to load and refresh data in power bi web. 

Regards,

Felipe Regis.

[collinq]

Hi @felipe_regis 

It appears that you have done quite a bit of testing.  I am wondering if the Desktop and the Service are both using the same credentials TYPE (windows, basic, anonymous...)  and privacy setting (none, public, org...)?  I have seen where if this is not the same then it doesn't work.