It is possible to connect from Outsystems server to PowerBi


I was wondering if it is possible to connect the data base that is on Outsystems server to PoweBI? 


Thanks

Hello João,

Welcome to the Forum.

There is a component in forge that does the contrary, uses PowerBI inside an OutSystems application:

https://www.outsystems.com/forge/component/1777/ms-power-bi/

To connect your OutSystems database to PowerBI, I think it is possible only if the installation is On Premises and you have access to the Database, as this is not possible (I think), if you are using the OutSystems Cloud servers.

Other than that, I don't know PowerBI, but if it can consume data through web services, you can create a web service in your application to allow it to fetch data from the database.

Cheers.

P.S. If it has an API (and I think it has), you can also check if it is possible to "send data to it". 

Hello João,


Complementing the answer of Eduardo, it is indeed possible to connect PowerBI to the OutSystems' databases, both on-premises or on the PaaS offering.


For the PaaS offering, you'll have to specifically ask OutSystems' support to give you access to the database as it doesn't come by default. However, this is a supported option that you can ask without extra costs.


Don't forget that OutSystems' physical tables inside the database follow an internal naming convention (OSUSR_xxx_*) that you'll have to deal with and/or query the platform's database (OSSYS_ENTITY, for instance) to know the relationship between the entity names in Service Studio and the physical table names on the database.


Hope this helps

Fábio