7 Connect Reports

The installation package that you extracted to the Base folder includes three Power BI templates that can now be connected to the SQL database created in Azure by the DeploymentScript.ps1.

The Power BI template files are named:

  • LS Insight Inventory.pbit
  • LS Insight Sales.pbit
  • LS Insight Hotels.pbit

Note: The LS Insight Hotels template will only work if you are running the LS Central for Hotels extension (available for version 15.3 and later) in your LS Central instance and have set up LS Insight for LS Central and Hotels.

Connect Power BI template with LS Insight database

  1. Now open either of the LS Insight template files. You need to repeat the following steps for each report template you want to publish to the Power BI cloud service.

    Note: You can find the information for the next two steps in the Parameters.json file that was created in the LS Insight deployment and saved with the project setup files.

  2. Enter Database and Server information from DeploymentSummary.json, and click Load:
    • Database = LSInsight - Database - FullyQualifiedDomainName for example:
      • lsinsight20211
    • Server = LSInsight - Server - FullyQualifiedDomainName for example:
      • lsinsight20211.database.windows.net

  3. Enter the login information (LSInsight - Server - UserName) from Parameters.json and the password that you selected for the LS Insight server admin and click Connect:

    Note: You will not see any data at this stage as firewall rules block direct access to the data in Azure from the local network. Once uploaded to the Power BI service, you will have access to your data. If you still cannot see any data after you upload, it might be because the pipelines have not run. You can always manually trigger the pipelines, if needed.

  4. Save your report and name it LS Insight. This will be the name of the dataset and report after you upload the report to the Power BI service.
  5. Publish the report to the Power BI service. We recommend that you create a workspace for the report and publish to that workspace (optionally, you can create a test workspace and try out the product and updates there).

Tip: If any of the visuals in the Power BI report are not visible when you view the report in Power BI desktop, you might need to turn on some preview features. You do that by navigating to File > Options and settings > Preview Features and selecting Smart narrative visual and Data point rectangle select.

Set the schedule refresh in Power BI

You can always click the Refresh button to load current data to the dataset. However, as all the data is loaded on each refresh, it can take a few minutes to load. It is therefore recommended to set a refresh schedule on the dataset. This is done in the dataset settings:

  1. In your workspace, go to the Datasets menu.
  2. For the LS Insight dataset, click the (…) under Actions and select Settings.
  3. Expand Scheduled refresh.
  4. Enable schedule refresh by turning the Keep your data up to date option to On.
  5. Set the Refresh frequency and Time.

    Note: In the current version it is not possible to automatically trigger Power BI to refresh after the data warehouse has been updated (this will be available later). Therefore, you will need to have the Power BI refresh the time set to refresh at minimum 2 hours after the ADF pipelines start (you can also add additional time to make sure). In the example we have been using this would be at 3 a.m. since the ADF pipelines start at 1 a.m.

  6. Now you are all set up and ready to go.

    Note: Depending on the data size, the initial load can take a long time. You can monitor the process in Azure, but be prepared to wait a few hours before data can be visualized in the Power BI reports.

Dataset items

If you are curious or have questions about the visible items in the LS Insight dataset from the Power BI Templates, it is a good idea to review them.

 

< Back