Requirement

 

APM database to be integrated with Power BI? Using APM on-premises and running SQL Server. 

 

Solution

PowerBI can connect directly to the SQL Server database and query the database for whatever information the user wishes to obtain. PowerBI gathers all the data that is requested and then stores that data in the PowerBI tables. The user can then interact with the data using the interface within PowerBI. The user is not querying live data, but using data that was copied from the last time it was pulled from the source system. Pretty much any resource online can help with that data query process as its just SQL Server technology and is very straight forward.

 If a user is running APM on the Bentley MAS cloud, then they would need to use the new OData technology to retrieve data. OData and SQL Server are both supported by PowerBI in order to gather information from a database, it's just a matter of gathering the data.

A challenge would be if there are no internal resources to assist with the database data model and to be able to make the relationships between the tables for the user's data needs.