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 user desires 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. User is not querying live data, but using data that was copied from the last time pulled from source system. Pretty much any resource online can help with that data query process as its just SQL Server technology and is pretty straight forward.

 If a User us 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, its 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 Users data needs.