Forum Discussion
Power BI Reporting Server Solution
Our client (Company A) and our project team has faced the difficulties below to deploy Power BI Report server solutions. Can you advise how we can get support on that?
Company A ’s Requirement:
Due to security concerns, users need to get the data in Company A ’s Oracle DB without directly connecting to Company A ’s Oracle DB.
Our current solution:
First, we create a Data Source connecting to Oracle DB in Power BI Report Server by using ADO.net Connector with SSL (Oracle Wallet). Then, we create a Dataset using the Data Source. And the last, users use Odata Feed connecter in Power BI Desktop/Excel or Postman to connect to the Dataset with Power BI user authentication with Company A's Active Directory.
The problems of current solution:
- Not able to load data into Power BI Desktop/Excel/Postman from Dataset using Odata when the amount of data is large (Timeout occurred), any sizing guide or limitation on this?
- Not able to create Data Source connecting to Oracle DB by using ADO.net by SSL with Wallet
The additional concerns:
- Limitations of concurrent user capacity
- Any other solutions could cope with the need required?
Thanks for your advice!