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
8 Replies
kclausen
Flexera
Flexera

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.

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

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

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. 

 

Hi KClausen,

 

Do you have any video for the Option A & B, so that I can understand well on connection between Power BI & IT Visibility.

 

Thanks,

Gokulnath

Gokulnath PL
0 Kudos

@gposanaan - The prior discussions here were for FlexNet Manager On-Premises, where you would have full access to the backend SQL database.

IT Visibility is a SaaS application and you would have no direct connection to the backend database.  You would need to use the CSV Extract or pull data from the API in order to create reports in Power BI using the data from IT Visibility.

@kclausen - Is there any other way to show case my Power BI with Live data of IT Visibility, other than download as .csv file. 

Gokulnath PL
0 Kudos

Since IT Visibility is a SaaS Application, you would not be able to connect Power BI to live data.  That would be true of any SaaS application.  You would be able to run Power BI off of data extracts only (CSV, API pulls, etc.)

Note that there will soon be new Ad-Hoc Dashboard reporting directly within the IT Visibility user interface that our Beta Testers are very excited with.