Forum Discussion

avk's avatar
avk
Frequent Visitor
9 years ago
Solved

Power BI Service connection to SQL Server on AWS EC2 instance

Hi All,   We have a SQL Server installed on AWS EC2 instance, we are trying to explore the possibility of having a secure connection from the Power Bi service to SQl Server on AWS. We are not explo...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi avk,

     

    As described in this document, to connect to database instance from Power BI service, only Databases in the Cloud and Databases on-premises (SQL Server Analysis Service) are supporte. For other types of databases in your organization, you’ll need to first use Power BI Desktop or Excel to connect to, query, and load data into a data model.

     

    Maybe you could submit this feature request at Power BI Ideas page. Your feedback is valuable for us to improve our products.

     

    Best regards,
    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi avk, I was also trying to connect SQL Server on AWS EC2 instance thru Power BI Desktop. Though when I was trying to connect to the database server, an error message says "Microsoft SQL: A network -related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible......"

In authentication method, I used Database and put my account (which has access to the SQL Server Database) as username and password.

 

Did I miss something here? How'd you succesfully connect your SQL Server in Power BI?

 

Thank you!