Connect Power BI report builder ( on-premise version) to multiple data sources

[nganguyensyntax]

Hi,

my company is using PBI Report server and want to build paginated reports. Data sources coming from different sources, cloud ( AWS, Azure) and on-prem SQL Database. The solution should be "no-cloud" so how can I achieve this? 

Thanks

[M_nwadibia]

If you are not using MS SQL server as your Database you will have to create connection between the DB and Report Server. In my own case was Oracle DB, I downloaded Oracle DB drivers and installed them which enabled the communication between data source and Report server.