Power BI integration

Verity has created several integrations with Power Bi so that you can enjoy your data stored in the Insights in Power Bi and display Power Bi graphics in Insights.

Connect your Power BI account in Verity

You can connect your Power PI account as an external services in the Insights at two levels:

  • At a user level: only the user will be able to connect to this Power BI account from the Insights.
  • At an account level: all the users will be able to connect to this Power BI account from the Insights.

You just need to connect your Power BI account and Insights once.

Tip

Learn more about External services connection.

Send your data from Insights to Power BI our Azure Table Storage

To send your data into Insights use the Report feature. You can choose the data you want to send and the frequency of data transmission. You can manually send the data when needed, or schedule it. The frequency of data transmission is selected in the report settings, it can be on a daily, weekly, monthly and yearly basis, or on-demand.

If you want to send a huge quantity of data in Power BI you may store it before in an Azure storage table.

Tip

Learn more about report schedule and reports notifications.

Display a Power BI visual in Insights

Once you have Verity data in Power BI you can use it to make advanced dashboards:

  1. Create a Power BI dataset with your data, or directly by sending the Insights report in Power BI, or by sending it first to Azure Table Storage then in Power BI.
  2. Create a report in Power BI based on your data set. You can schedule the refresh of the Power Bi report directly in Power BI.
  3. Pin tiles of your report into a Power BI dashboard.
  4. You can then display the graphs of these dashboards in the Insights.

You just need to create a tile in a dashboard, and select Power Bi as a data source. You will then need to select your Power BI account, dashboard and tile. Each time the dashboard will be opened the data will be refreshed. You can also manually refresh it by reloading your browser page with the F5 key.

Tip

Learn more about dashboards.