Doubt with the kind of Gateway

[Anonymous]

Hi everyone!

I have many doubts with the gateway that I would have to use for my power BI.

My archive of Power BI desktop has 2 sources: one from SQL Server and another from Google Analytics. In my local everything is right when I refresh the data but when I publish online the refresh failed.
If I use the personal Gateway the SQL server conexion fail but If I use On premise Gateway I can´t use Analytics but the SQL server works fine.

Any idea?

[v-qiuyu-msft]

Hi @Anonymous,

In your scenario, as the dataset contains the data sources connect to SQL Server and Google Analytics, we can only use the personal gateway. As data gateway cna't configure data source for the Google Analytics now. You can see this idea: Combine enterprise gateway and online data sources.

As you mentioned the SQL server data source is failed when using personal gateway, please check if the credential entered in service is the same as in desktop. Make sure the computer which hosts personal gateway can access the SQL Server. You can install the personal gateway in the computer which install the desktop.

Best Regards,
Qiuyun Yu

[Anonymous]

Thanks for your words @v-qiuyu-msft,

The thing is that I have been doing tests with my archive, I deleted the Analytics Source and I have worked only with the SQL server source.I have two copies of the same power BI: one that uses Personal Gateway and other with On premise Gateway.

The copy of the On Premise Gateway refreshs fine but the copy with the Personal Gateway gives me this error:

My computer which hosts personal gateway, can access the SQL Server.

Any idea?

[v-qiuyu-msft]

Hi @Anonymous,

Please try to update the personal gateway to the latest version. Make sure the personal gateway is running.

Best Regards,
Qiuyun Yu

[Anonymous]

Hi @v-qiuyu-msft!

I have the last versión of personal gateway and I have running both gateways (Personal and On premise).

Can there be any kind of conflict between the two gateways?

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

I see personal gateway is running now, please select the personal gateway for the dataset, then go to Data Source Credentials, enter credentials for both SQL Server and Google Analytics. See: Configuring scheduled refresh.

Best Regards,
Qiuyun Yu

[Anonymous]

Hello,

Yesterday I decided to delete the dataset, the gateway, the report, everything....

And do everything from zero.

Now the SQL refresh works with both gateways (Analytics only with personal gateway).
I don´t know what was the problem exactly.

Thanks for your time @v-qiuyu-msft