Solved: AWS RDS Direct query SQL database

Anonymous · ‎07-08-2020

We have created an AWS RDS public facing SQL Server standard 2017 instance. I am able successfully connect to the database in Power BI Desktop using the Direct Query. I have created my charts and published them to the powerbi.com website.

When i try to view the charts on the PowerBI.com website, i get the error "there is no gateway to access the data source"

The AWS RDS is public facing with 0.0.0.0/0 and I entered the database credentials into the Power BI desktop tool, and it works correctly in the power bi desktop. However, it doesn't work on the PowerBi.com site.

I must use directquery, i can't use import

any help is appreciated

luisrh · ‎07-08-2020

you need to install a power bi gateway in AWS that exposes that DB in AWS. The power bi service runs in Azure and the gateway is needed to access data sources in other clouds and on premises.

So, either you put your data in SQL Azure db (which is directly accessible thru power bi service) or provide the gateway. Those would be your 2 options.

View solution in original post

luisrh · ‎07-08-2020

you need to install a power bi gateway in AWS that exposes that DB in AWS. The power bi service runs in Azure and the gateway is needed to access data sources in other clouds and on premises.

So, either you put your data in SQL Azure db (which is directly accessible thru power bi service) or provide the gateway. Those would be your 2 options.