Forum Discussion

nganguyensyntax's avatar
nganguyensyntax
Frequent Visitor
2 years ago

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

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

1 Reply

  • 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.