Forum Discussion
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 you can reach them via a secured data management gateway, but how about Power BI Desktop?
We've sited our databases in our highly secured and zoned datacenter. There are no possibilities to connect from a local desktop direct to a sited database. All connections have to be decoupled, there's a so-called steppingstone needed to connect to our databases. Examples of a steppingstone are citrix, vdi's, proxy's, etc.
What options do we have to connect from Power BI Desktop to our sited databases?
Regards!
7 Replies
What type of database do you connect to? You are able to connect to the database from Power BI gateway, right? If so, you can install Power BI Desktop on the same machine with Power BI gateway.
Both Power BI Desktop and Power BI gateway are clients. Since you can successfully connect to database from gateway, you should be able to connect to the database from Power BI Desktop.
Regards,
LydiaHi,
We're connecting to SAP HANA and SAP BW. It should be possible to install PBD on the same server, but the issue is that we're not allowed to connect from a local desktop directly to a sited database or server. A form of steppingstone is required. So we can distribute Power BI Desktop with Citrix or a VDI, but that's not optimal in our situation. I'd like to install it as a local desktop application, but i'm not familiar with the possibilities to decouple the PBD-application from the sited databases. I was under the assumption that the gateway would fix this for me, but unfortunately...
I hope to find someone who has dealt with this before.
Regards,
PBI_USER,
What error message do you get when connecting to the data source in Power BI Desktop?
Regards,
Lydia
