Forum Discussion
Impactful Individualconnecting relational and OLAP databases concurrently
is it possible to connect both RDMS (sql server, oracle) and OLAP ( SSAS , SAP BW) concurrently in power bi?
Hi powerbiexpert22 Yes, you can connect both RDBMS (SQL Server, Oracle) and OLAP (SSAS, SAP BW) concurrently in Power BI using built-in connectors. Use composite models or mixed storage modes to unify data and optimize performance.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
4 Replies
- Akash_Varuna
Super User
Hi powerbiexpert22 Yes, you can connect both RDBMS (SQL Server, Oracle) and OLAP (SSAS, SAP BW) concurrently in Power BI using built-in connectors. Use composite models or mixed storage modes to unify data and optimize performance.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance 
v-karpurapudCommunity Support
Could you please confirm if your query have been resolved the solution provided by Akash_Varuna ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you
- v-karpurapud
Hi powerbiexpert22
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you. - v-karpurapud
Hi powerbiexpert22
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.