Power BI

Integrate YSoft SafeQ with Power BI

Prerequisites

Option 1: Import Y Soft Template

To enjoy the full potential of Power BI, one will need to develop a Power BI template for the organizations specific enterprise reporting requirements. However, to get a head-start on such an effort, Y Soft has developed a set of Power BI templates. You can find full description of template import in Power BI Desktop - Import Template article.

Option 2: Create Your Own Report

  1. Import data from a SQL Server database.

  • PostgreSQL server database engine:

  1. Install ODBC driver, see PostgreSQL ODBC driver for Power BI.

  2. Select More option as shown below.

    images/download/attachments/160480449/Power_BI_Desktop_More.png



  3. Select PostgreSQL database option.

    images/download/attachments/160480449/Power_BI_Desktop_PostgreSQL_database.png



  4. Specify the IP address of the database server and name of the database associated with YSoft SafeQ:
    At this point you may need to add Npgsql dependency for Power BI.

    images/download/attachments/160480449/Power_BI_PostgreSQL_database.png
  • MS SQL server database engine:

    1. Install ODBC driver, see MS SQL ODBC driver for Power BI.

    2. Select SQL Server" option as shown below.


      images/download/attachments/160480449/Power_BI_Desktop_SQL_Server.png

    3. Specify the IP address of the database server and name of the database associated with YSoft SafeQ:

  1. Filter data mart tables in Navigator and select all tables with prefix "dwhtenant_1.dm_v2". Click on Load button.

  2. Wait for the data to load, this step takes a few minutes, depending on the database size.


    images/download/attachments/160480449/Power_BI_Navigator_2.png

  3. Result - The relationship diagram between the tables is available on vertical tab Relationships.


    images/download/attachments/160480449/Power_BI_result_relationships.png

Add a Sample Graph

  • Generate Chart - Select the Power BI report view from the left pane and select various data to create and render different charts. For example, what is depicted is a simple selection of the ACCID dimension rendered into a Bar Chart.

images/download/attachments/160480449/Power_BI_result_report.png


References: