Forum Discussion
Connecting Power BI Desktop to on premises data
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,
Lydia
Hi,
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,
LydiaHi 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,
Lydia