BeyondERP.Newsletter
Menu

Setup step on the Entity Store page · System administration

Set up Entity Store

Use this page to refresh aggregate measurements in Entity store, on demand or on a schedule, so that analytical workspaces and Power BI reports show current data.

Used by
Information technology manager
Business process
Administer system features
Menu item
BIMeasurementDeployManagementEntityStoreMenuItem
Main table
BIMeasurement
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page that lists the aggregate measurements that can be deployed to Entity store, the data store used for reporting and analytics.
What you do hereUse this page to refresh aggregate measurements in Entity store, on demand or on a schedule, so that analytical workspaces and Power BI reports show current data.
ExampleFor example, to see data in the Financial analysis workspace, an administrator updates entities such as Financial reporting transaction data version 3 and Sales cube.
Entity Store 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 › Entity Store
Used next byDeploy Power BI files Microsoft Learn Batch jobs Microsoft Learn
Related pagesPowerBI.com configuration Microsoft Learn
In this process Set up Activity plans · Set up Activity types
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 Entity Store1 screen

Use this page to refresh aggregate measurements in Entity store, on demand or on a schedule, so that analytical workspaces and Power BI reports show current data.

  1. Screen 1

    Review the Entity store measurements

    Go to System administration > Setup > Entity Store

    1. Select an aggregate measurement in the list on the left
    2. Review the refresh options and when it was last updated
    3. Select Edit and turn on Automatic refresh enabled to refresh it on a schedule, or select Refresh to refresh it now
    Review the Entity store measurements (zoomed on the outlined fields)
    Show the full screenReview the Entity store measurements
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > Entity Store.
  2. Select the aggregate measurements that need to be refreshed.
  3. Select Refresh.
  4. Select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Aggregate measurementA measurement that can be deployed to Entity store and refreshed.Microsoft Learn Sales cube
Refresh intervalWith automated refresh, how often the measurement is refreshed: every hour, twice a day, once a day or once a week.Microsoft Learn Once a day

Common errors and fixes

MessageWhat to do
The credentials provided for the SQL source are invalid.Refresh the Entity store measurements, then redeploy the affected report from Deploy Power BI files (export any PowerBI.com customizations first). Microsoft Learn

Test checklist

  1. On Entity Store, check that the automated refresh experience is shown.
  2. Check that every measurement used by an analytical workspace has a refresh interval set.
  3. Select a measurement and select Refresh.
  4. Open the related analytical workspace and check that it shows current data.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Entity StoreSwitch to Automated Entity store refresh and set a refresh interval (every hour, twice a day, once a day or once a week) on each aggregate measurement that reports useWith automated refresh the system schedules and manages Entity store refresh, so administrators don't have to schedule or monitor refresh batch jobs.How is Entity store refreshed?Not checking the measurements after the switch. Turning on automated refresh can disable refresh of some aggregate measurements, so revisit each one and set its interval.Test: Measurements refresh on their interval

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. IT administrators refresh measurements. Automated Entity store refresh is turned on with Switch now on this page, not in Feature management, and can't be turned back. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneOne-way: Warning: Switching to Automated Entity store refresh can't be reversed; you can't go back to the old refresh experience.
If you change it laterSwitching to Automated Entity store refresh can't be undone, and afterwards the refresh intervals of the aggregate measurements should be checked. Microsoft Learn
Technical architect

6Technical

Menu itemBIMeasurementDeployManagementEntityStoreMenuItem Checked in Dynamics 365
FormBIMeasurementDeployManagementEntityStore Checked in Dynamics 365
TableBIMeasurementShown as “Measurement” in Record infoChecked in Dynamics 365
Who can open itPrivilegesDeploy measurement BIMeasurementDeployManagementPrivilegeDutiesMeasurement deploy management BIMeasurementDeployManagementDuty
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=BIMeasurementDeployManagementEntityStoreMenuItem
Data migrationLoad order: Entity Store has no data entity in Data management, so it can't be loaded from a file or a configuration template. Entity store is filled by refreshing the measurements in each environment.Checked in Dynamics 365
Table definitionBIMeasurement columns and relations Microsoft data model
Everyone

8Sources