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

Audit Microsoft SQL Server table with many columns
Select joining table based on condition
Linked server with same server name
How to group by two dates to sum an quantity
Retrieving record to a combo box in vb.net
Need select 2 rows from Table2, which is joined with Table1. See description
Can't add a connection in Visual Studio: no server name available
Average of a date column in sql [duplicate]
How to get the previous row value with an ORDERING BY DATE?
How to disable/enable full text indexed in SQL Server using dynamic SQL?
Generate DDL (Create) in SSIS from an Input Source
SQL Server Foreign Keys across multiple table levels
Delete some symbols from Sql Server
error of loading geometry data from csv file to Spatialite
TSQL: how to eliminate join on Null values when Column value is available
Create multiple foreign keys referes to the same table in EF code first

Categories

HOME
symfony
crate
amazon-swf
scipy
ocaml
otrs
mapbox-gl-js
ubuntu-12.04
mainframe
webdav
ll
codeblocks
desktop
octopus-deploy
pca
criteria
x11
store
lenskit
jpeg2000
eclipselink
ip-camera
excel-2010
prediction
spring-ws
memsql
delete-file
http-method
continuous-deployment
osmdroid
classpath
thinking-sphinx
google-guava-cache
nunit-3.0
mms
installshield-2012
s3cmd
soundjs
wsadmin
context-free-language
email-parsing
ajp
nstouchbar
shutdown
etherpad
gmt
rxvt
iron.io
pspice
atlassian-crowd
c#-interactive
scalar
linkageerror
spring-lemon
remoteapp
django-south
asymptote
insertion-sort
unity5.3
mysqldumpslow
ffserver
gray-code
belongs-to
mser
adcolony
spdy
sgml
data-generation
ksoap2
edit-in-place
argb
shortcuts
device-emulation
sametime
phpsh
qsqltablemodel
radchart
legacy-code
point-sprites
django-nose
authenticode
adsl
ihttphandler
idictionary
visual-studio-dbpro

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