BeyondERP.Newsletter
Menu

Setup page · System administration

PowerBI.com configuration

A setup page where administrators connect the system to PowerBI.com, so users can pin Power BI tiles, dashboards and reports to workspaces.

Business process
Administer system features
Menu item
PowerBIConfiguration
Main table
PowerBIConfig
Data entity
PowerBIConfigurationEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where administrators connect the system to PowerBI.com, so users can pin Power BI tiles, dashboards and reports to workspaces.
What you do hereUse this page for the one-time setup that lets Power BI communicate and authenticate correctly with the system.
ExampleFor example, to show the Global Inventory Accounting report, an administrator turns on the integration, enters the application ID and key, and then opens the report catalog.
PowerBI.com configuration page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Setup › PowerBI.com configuration
Set up firstApp registration in Microsoft Entra ID Microsoft Learn
Related pagesDeploy Power BI files Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up PowerBI.com configuration1 screen

Use this page for the one-time setup that lets Power BI communicate and authenticate correctly with the system.

  1. Screen 1

    Review the PowerBI.com configuration

    Go to System administration > Setup > PowerBI.com configuration

    1. Select Edit
    2. Turn on Enable PowerBI.com integration
    3. Enter the application ID and application key from your Microsoft Entra ID registration
    4. Select Save
    Review the PowerBI.com configuration (zoomed on the outlined fields)
    Show the full screenReview the PowerBI.com configuration
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > PowerBI.com configuration.
  2. Select Edit.
  3. Set the Enabled option to Yes.
  4. In the Application ID field, enter the application ID from the Microsoft Entra app registration.
  5. In the Application key field, enter the secret value from the app registration.
  6. Select Save.
  7. Select Get started to check the connection and pin tiles to a workspace.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
EnabledTurns the PowerBI.com integration on.Microsoft Learn
Application IDThe application (client) ID of the app registered in Microsoft Entra ID for Power BI.Microsoft Learn ClientID
Application keyThe secret value created for that app registration.Microsoft Learn ApplicationKey

Common errors and fixes

MessageWhat to do
Sorry, something went wrong. The authentication process wasn't successful. Contact your system administrator.The service keys have probably expired: redo the app registration from step 3 and enter the new values on PowerBI.com configuration. Microsoft Learn
The Power BI service is unavailable.No re-registration is needed; try pinning the tile again later. Microsoft Learn

Test checklist

  1. Enter the Application ID and Application key, set Enabled to Yes and save.
  2. Open a workspace and select Get started on the Power BI area.
  3. Authorize the connection and accept the consent prompt.
  4. Pin a tile from your PowerBI.com account and check that it shows in the workspace.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up PowerBI.com configurationEnabled = Yes, with the Application ID and secret of a single-tenant Entra app (Web, redirect URI ending in /oauth) that has the delegated Power BI Service permissions and admin consentThis one-time setup lets the server call Power BI on behalf of each user, so users only see tiles and reports from their own PowerBI.com account.Which app registration does PowerBI.com use?Letting the client secret expire. Authentication then fails until the registration is redone and the new values are entered on this page.Test: A Power BI tile pins to a workspace

Feature management and licence

Licence or add-inIT administrators set it once per environment. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: one configuration for the whole system (the PowerBIConfig table has no company field). Microsoft data model
Can it be undoneReversible: Change the Application ID and Application key or turn Enabled off at any time; pinned tiles depend on these values. Microsoft Learn
If you change it laterWhen the app's service keys expire, authentication fails until the registration is redone and the new values are entered on this page. Microsoft Learn
Technical architect

6Technical

Menu itemPowerBIConfiguration Checked in Dynamics 365
FormPowerBIConfiguration Checked in Dynamics 365
TablePowerBIConfigShown as “Power BI configuration” in Record infoChecked in Dynamics 365
Data entitiesPowerBIConfigurationEntityPower BI configuration Microsoft data model
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PowerBIConfiguration
Integrate withPowerBIConfigurationEntity data entity Microsoft data model
Data migrationPowerBIConfigurationEntity (Power BI configuration): shared by all companies. Enter the Application key again in each environment: it is the secret of the app registration.Load order: PowerBIConfigurationEntity isn't in any of Microsoft's default templates in BEAT, so add it to your own data project when you move this setup.Checked in Dynamics 365
Table definitionPowerBIConfig columns and relations Microsoft data model
Everyone

8Sources