tallal85
Active participant

Power BI connexion

Hello community,

My client wants to connect power BI with Flexera, I want to know is there a connector from the beacon? or do you have to connect it directly to the sql server?

thank you.

Regards,

OT

0 Kudos
4 Replies
kclausen
Flexera
Flexera

Re: Power BI connexion

Assuming that your client has FNMS On-Premises and they want to create reports from FlexNet Manager data using Power BI, then you would need to connect Power BI directly to the FNMS SQL Server database.

A couple options to consider:

Option A - creating a "Reporting" database that Power BI connects to.  This would be a standard SQL Server backup and restore of your FNMS Compliance Database.  With this method, having active Power BI connections to the reporting database will not interfere with the normal operations of FlexNet Manager and cause database contention.

Option B - Determine what data is required from FlexNet Manager.  Set up a separate SQL Server database where you have a simplified database schema where your data has been "Flattened Out".  You would then need to create SQL Scripts/Jobs to extract data out of the FNMS database and insert into your new SQL Database.  You can then connect Power BI to this database, with a simpler database schema.

mfranz
Shining star

Re: Power BI connexion

Option C -  Directly access the FNMS databases (read only). Maybe limit what can be accessed, by providing dedicated views. In some very complex cases, we pre-compile reporting data into dedicated tables, so they are not calculated during the report.

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos
jean_martel
Active participant

Re: Power BI connexion

Hi, I am interested in option A. But Can I just create VIEWS of each DB, Tables and create a connection for PowerBI? 

0 Kudos
JeffVoss
Intrepid explorer

Re: Power BI connexion

You might be better off using SQL server management tool to determine what you need and write your queries to ensure you have the data limited to only the fields you want and use an advance connection that uses the query directly in the Power BI data provider.  That will keep the data structures standard FNMS on Prem and will not have any upgrade issues with the database due to views and tables not owned by the appropriate account. It will also limit your Power BI server or service from having to pull as much data into the system.