Publishing to Power BI Service (Direct Query AWS RDS Datasource)

[johnbradbury]

Evening all. I'm coming back to Power BI after quite a break, so I'm a little rusty.

I have an AWS RDS database which I'm connecting to as a datasource in PowerBI Desktop. I want to publish these reports to the rest of my department, with the ability to refresh the data (direct query). What's the best/easiest way to do this?

[GilbertQ · Accepted solution]

Hi @johnbradbury 

You would need to install a Gateway and configure the AWS RDS Database as a data source.

Then you will be able to use DirectQuery