Forum Discussion
Connecting Power BI Desktop to on premises data
PBI_USER,
What error message do you get when connecting to the data source in Power BI Desktop?
Regards,
Lydia
Hi Anonymous
I don't get an error, because I didn't try it. The IT department decided to site all databases in a zoned datacenter, so I know for sure that I can't reach any database at all from my local workstation. I'm looking for something to decouple my workstation from the database, something like a service, application or proxy or something to place in between my workstation and the concerning databases. So we can bypass a citrix solution.
Regards,
PBI_USER,
The gateway also requires connectivity to the data source. If the data source is not accessable from Power BI Desktop, the gateway is not be able to connect to it.
Regards,
LydiaHi Anonymous,
The gateway wíll be able to connect to the datasaource, that's not the problem. It will be used by Power BI service, the gateway will decouple the cloud environment from our on premises datasources. So far so good.
However, Power BI Desktop (local installation) has to be decoupled as well. My question is; how can we do this without using Citrix... Is there a gateway-like service (microsoft or 3rd party) that we can install in the same zone as our source database, so that the local install can be decoupled from the sited databases (by a proxy or something)?
Regards!
I am not sure how you use on-premise gateway to connect to the data source. But as long as you can add the data source within the gateway, you should be able to use same connection string in Power BI Desktop. And the Desktop can be installed on the same machine with gateway.
Regards,
Lydia