BC Observatoryunofficial, made by waldo
videoReporting & Analyticsofficial - Microsoftreviewed - checked by Opus

Connect Power BI Telemetry Apps to Read your Business Central Telemetry Data (2023)

Connecting the Business Central Telemetry Power BI apps (environments or apps) to real data instead of sample data. Covers setting the Application Insights ID, time zone and refresh period in Power BI, then authenticating with OAuth to Application Insights.

Open in ClaudeBOY2442wHSc.md
  1. 0:00 Introduction to Power BI Telemetry Apps
  2. 0:20 Connecting Your Data to Power BI
  3. 0:41 Finding the Application Insights ID
  4. 1:18 Configuring API Access and GUID
  5. 1:58 Setting Time Zone and Refresh Period
  6. 2:20 Authenticating with Application Insights
  7. 2:56 Completing the Setup
video Microsoft Dynamics 365 Business Central (YouTube) · 2023-12-05Watch on YouTube

Overview

After the Business Central Telemetry Power BI app is installed, it shows sample data. The video shows how to use the “connect your data” banner menu to point the app at actual telemetry in Azure Application Insights.

Key points

  • After installing the Power BI telemetry app (for environments or for apps), the report shows sample data until it is connected.
  • Select ‘connect your data’ in the banner to open the configuration menu.
  • The most important setting is the Application Insights ID.
  • In Application Insights, open Configure, then API access, to find and copy the application ID GUID.
  • Set the report time zone to match the customer location; the demo uses Copenhagen.
  • Set the refresh look-back period (weekly, daily or monthly); the report refreshes nightly with that period.
  • Finish by authenticating to Application Insights with OAuth 2.0 using your user credentials, so the report can refresh.

Features

Every feature below: status not stated, demoed.

Feature At
Power BI Telemetry Apps for Business Central 0:00
Data Connection Configuration for Power BI 0:20
API Access Menu for Application Insights ID 0:58
Time Zone Configuration for Reports 1:38
Refresh Period Configuration 1:58
OAuth Authentication for Application Insights 2:20

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

  • other “API Access menu” at 0:58
  • other “Configure menu” at 0:58

Quotes

  • 0:00 “when you have installed the powerbi app for business business Central Telemetry whether it is for environments or for apps you notice that you”
  • 0:20 “if you click connect your data you get a menu where you need to set certain things the most important thing you need to”
  • 0:58 “under the configure menu there’s a menu called API access let’s go here and this is where the application ID resides”
  • 1:58 “when the report refreshes you can set a weekly or daily or a monthly so it every night it will refresh with that look”
  • 2:20 “I need to authentic at to um to application insights using or so there will come a small menu up here in a second”