cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Azharuddin Frequent Visitor
Frequent Visitor

With the Dynamics 365 for Finance and Operation, Enterprise Edition, July 2017 release I discovered

With the Dynamics 365 for Finance and Operation, Enterprise Edition, July 2017 release I discovered the menu item “Entity store” found under System administration > Setup. The form contain a number of “Aggregate measurements”.

Microsoft define aggregate measurements in the following way:

“An aggregate measurement is a model that contains a collection of measures together with their corresponding dimensions. Measures are aggregate numbers, such as Total Sales or Number of Orders. Dimensions are slicers, such as Product, Vendor, or Customer Microsoft Dynamics CRM Training, that help you analyze the measure. For example, the measure of Total Sales isn't useful unless it can be sliced by Product, Region, and Customer.”

“You can create data entities by directly referencing aggregate measurements and aggregate dimensions. These are known as aggregate data entities. Aggregate data entities are read-only data entities that are used for reporting purposes.”

 

1. History

In different versions of D365 the number of aggregate measurements have grown over time and the July 2017 release contain 48 different aggregated measurements.

 

2. Power BI Embedded

Power Bi Embedded provide the user information about different topics from a direct query to aggregate measures in the entity store. It is an Azure service that current is available in nine data centers. It is not a free service but it does not require a Power BI.com user license.

The difference between Power BI.com and Power Bi Embedded are illustrated in this drawing found here: https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/power-bi-embedde...

 

3. Demo environment deployed

After deploying a demo environment, I want to use one of the workspaces that contain Power BI Embedded functionality. When I select the workspace, I receive the following message. “Power Bi embedded is not enabled. Please contact your system administrator”.

I tried to Google myself to a solution but did not find a description on docs.microsoft.com.

 

4. Enable Power BI Embedded

One of my colleagues came across a document with the title “Activate the new Power BI Embedded Reports from July 2017 Update = Dynamics 365 for Finance and Operations QUICK AND DIRTY !!!” posted by Helmut Wimmer 5. July 2017.

After following the described approach the Power Bi Embedded it is now possible to get access and use Power BI embedded in D365.

 

5. Refresh aggregate measurements

Before you can use Power BI embedded the different aggregated measurements you are going to use they have to be refreshed. This is done from System administration > Setup > Entity store. Select menu item “Refresh”. It runs by default as recurrence every minute.

 

6. Workspaces and menu items

Power Bi Embedded and Power BI.com functionality are available mainly in workspaces but a few Power Bi Embedded are located in specific menu items.

In the picture below a red square indicates that the workspace contain Power BI Embedded and a yellow color indicates that the workspace contain Power BI.

 

7. Power BI embedded functionality

Several workspaces show the Power BI Embedded KPI’s when you open the workspace e.g. CFO Overview:

Other have the functionality on an “Analytics” pane in the workspace, e.g. “Manage customer credit and collections”.

At least one Power Bi Embedded is available from a menu item, e.g. Production control > Inquiries and reports > Production performance analysis > Production performance:

In the right side of an Analysis form filter functionality is available. It is intuitive and easy to change the filter functionality and it update the KPI’s immediately. :-)

3 REPLIES 3
Community Support Team
Community Support Team

Re: With the Dynamics 365 for Finance and Operation, Enterprise Edition, July 2017 release I discove

HI @Azharuddin,

 

Thanks for your sharing. Smiley Happy

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mucis727 Occasional Visitor
Occasional Visitor

Re: With the Dynamics 365 for Finance and Operation, Enterprise Edition, July 2017 release I discove

Hi,

 

Could you please share the article if you or your colleague can still access it?

 

I am not able to find the way to enable Power BI embedded and still have the same issue.

 

Thank you.

 

regasanyoto Member
Member

Re: With the Dynamics 365 for Finance and Operation, Enterprise Edition, July 2017 release I discove

Hello @Azharuddin,

 

Thanks for sharing this article!

 

I am trying to find out which of the entity list should i refresh for getting data into the CFO OVERVIEW report in Dynamics.

 

Does anyone knows?

 

Many thanks!

 

Greets,

 

Rega

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 376 members 3,690 guests
Please welcome our newest community members: