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.
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