Skip to main content
Microsoft Idea

Power BI

Under Review

AWS RDS SQL Server data source

Vote (198) Share
Michael Moore's profile image

Michael Moore on 06 Dec 2014 10:30:04

Comments (37)
Michael Moore's profile image Profile Picture

Vaishak on 05 Jul 2020 23:07:58

RE: AWS RDS SQL Server data source

Please implement this. I believe we are behind times now.

Michael Moore's profile image Profile Picture

Bert Clybouw on 05 Jul 2020 23:03:56

RE: AWS RDS SQL Server data source

This option is really necessary. It can't be diffilcult to implement.

Michael Moore's profile image Profile Picture

Richard on 05 Jul 2020 22:59:41

RE: AWS RDS SQL Server data source

yes this needs to be over SSL too and support direct queries otherwise we won't use it!

Michael Moore's profile image Profile Picture

Power BI User on 05 Jul 2020 22:58:51

RE: AWS RDS SQL Server data source

Shame there isn't any movement with this. I hope the small number of votes doesn't mean it's not important.

Michael Moore's profile image Profile Picture

Rajesh on 05 Jul 2020 22:58:03

RE: AWS RDS SQL Server data source

any update here

Michael Moore's profile image Profile Picture

Richard on 05 Jul 2020 22:54:08

RE: AWS RDS SQL Server data source

Please add direct query too, otherwise the Enterprise gateway will have to run on a schedule to sync the data. Direct query is something most BI Visualization tools have out of the box, it's strange PowerBI doesn't.

Michael Moore's profile image Profile Picture

Nishanth Kadiyala on 05 Jul 2020 22:53:07

RE: AWS RDS SQL Server data source

You can leverage the on-prem connector offered by DataDirect's Hybrid Connectivity Services. With their patented on-premises connector technology, you won't have to open any ports. This Data API gateway offers secure access to on-prem data sources using standard OData or ODBC connections.

Michael Moore's profile image Profile Picture

Eneko on 05 Jul 2020 22:46:02

RE: AWS RDS SQL Server data source

I just really need this, for real.

Michael Moore's profile image Profile Picture

Will on 05 Jul 2020 22:43:21

RE: AWS RDS SQL Server data source

I can connect to RDS SQL Server by using SQL Server option and Direct Query. However a pro license is required when you "publish to web" from the desktop version.

Michael Moore's profile image Profile Picture

Daniel Meresa on 05 Jul 2020 22:39:22

RE: AWS RDS SQL Server data source

this is key features to use PowerBI on top of AWS RDS.