Forum Discussion

KevinColes's avatar
KevinColes
Helper III
3 years ago

Connecting Desktop to a remote SQL Server

Hi everyone, I have a situation where I need to be able to develop in Desktop against both an ODBC data source in the cloud as well as a local server. Here is a high level view: Main data source...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

 

so we installed a SQL Express instance on the Gateway server

 

Highly not recommended. They will fight tooth and nail for the available RAM and compute cycles.  At a minimum you should set a RAM limit for the SQL server.

 

The solution to your problem are -sadly- dataflows. (Or - gasp- datamarts, if that is your thing)  They allow you to run the ETL in a walled-off environment but still be able to create your reports from whereever.

KevinColes's avatar
KevinColes
Helper III
3 years ago

The SQL Express has one database with one table with only 6 columns and is updated daily with about 3K rows (only takes maybe 2 min). Power BI serice is updating once a night through the gateway at a different time so I'm not overly concerned about the performance.

In the end I was able to get an ODBC connection into the Gateway from my local machine so this will work.

Thanks!