Forum Discussion

PBI_USER's avatar
PBI_USER
New Member
8 years ago

Connecting Power BI Desktop to on premises data

Hi there!   We're doing a proof of concept with Power BI right now, a cloud subscription with premium license. Our sourcesystems, two datawarehouses, are residing on premises. With Power BI Service...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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,
Lydia

PBI_USER's avatar
PBI_USER
New Member
8 years ago

Hi 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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    PBI_USER,


    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