sql-server


How to connect Power BI to MS SQL through dataGateway only


I need to connect to a MS SQL server that is on an amazon AWS virtual machine.
I downloaded and configured the enterprise data gateway and in my Power BI web interface it says connection successful.
But in my Power BI desktop how do I access the MS SQL server using this gateway? I cannot connect directly to this MS SQL server from my desktop
I tried get data and entered the IP which matches the IP I used when I setup the data gateway but it does not work.
How can I connect from Power BI Desktop to my cloud based MS SQL through the gateway then I have no direct access to the MS SQL server from my desktop?
As far I understand it, the gateway is not a data source from the perspective of Power BI Desktop's Get Data. You need access to the SQL Server. The gateway comes into play for users who will connect from powerbi.com.
Reference:
https://community.powerbi.com/t5/Community-Blog/Connecting-Power-BI-to-On-Premise-data-with-Power-BI-Gateways/ba-p/84797
When developing reports using an on premise data source and the on-premises gateway, it is necessary to develop the reports in the Power BI Desktop tool. The Power BI Desktop tool must be used from a machine that has access to the on premise data source.

Related Links

Microsoft SQL Server: wrong query execution plan taking too long
Best way to handle updates on a table
Retrieving XML Data from sql server
Azure Recovery Vault Backup is failing for SQL VMs
excel via for Mac 2011 SQL Server
multiple declare statements with one creating a temporary table
SQL Query is taking infinite time when using with order by
SAS query issue on external DBMS TABLE where Column Name has space
Try-Catch with Stored Procedures in SQL server
Is there an analogy between a recursive SQL query and a recursive function?
stored procedure 'auto_pk_for_table' not found
OUTPUT is not displaying more than ch3794, col 3794, Ln 35,
Insert/update datetime from VB6 to SQL Server
When calling process from SQLCLR, must the called process be 64bit?
SQL Server 2008 - Computed Column Extract Only Numeric From Other Column [duplicate]
Simple SELECT query with calculated columns returns error

Categories

HOME
tensorflow
ajax
meshlab
nlp
mapping
youtube-livestreaming-api
tomcat7
orientation
terrain
histogrammar
gspread
i2c
shader
rfid
maxima
sendkeys
reduction
uicollectionview
phpbb
rhapsody
zend-framework-mvc
vs2017
rails-activerecord
facebook4j
spring-test
http-method
shopping-cart
printdocument
aurelia-binding
referenceerror
picturebox
postgresql-9.2
outsystems
modelandview
rhomobile
reactivemongo
rider
jboss-esb
pmwiki
readfile
code-behind
ssh.net
lftp
python-idle
shutdown
decompress
struts-layout
info
quintus
python-hypothesis
vici
activeweb
wcf-ria-services
radians
shipitjs
anti-cheat
mfc-feature-pack
schtasks.exe
application-loader
android-snackbar
futuretask
stream-framework
prezto
ffserver
pgm
sysfs
ctrlp
cocoascript
left-recursion
google-admin-audit-api
mov
power-law
emma
adaptive-compression
bsp
kraken.js
dynamic-proxy
pyjade
ng-hide
pep8
redirectstandardoutput
objective-c-protocol
concurrent-programming
makefile-project
electronic-signature
coff
opengl-es-lighting
msn
chdatastructures
linfu
graph-layout

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App