Top 10 reasons to choose Microsoft Power BI

According to Microsoft, Power BI empowers your teams with industry-leading business intelligence (BI) and augmented analytics so that you can simplify decision-making in a world of increased complexity and growing data volume. There are many different BI tools available but Power BI is one of the best tools. It provides more than 100 different connectors... Continue Reading →

Get employee’s manager from the dataverse

In this article, We will see how to get employee's manager from the Dataverse. We have a manager field in the worker entity however it is always blank. Follow below steps to get the manager record from the dataverse. Entities required cdm_workercdm_jobpositioncdm_positionworkerassignmentmaps Relationships Parent tableChild tableCardinalityCdm_workercdm_positionworkerassignmentmaps  1 : NCdm_workerCdm_jobposition1 : NCdm_jobpositioncdm_positionworkerassignmentmaps  1 : N Get... Continue Reading →

Visualize data in model-driven apps with Power BI

Microsoft announced the availability of Power BI quick reports in model-driven apps in preview. This update combines the capabilities of Power Apps, Power BI, and Dataverse in a seamless way to help you visualize and understand your data – with one click. How to enable Power BI quick report visualization To enable this feature, you... Continue Reading →

Create a Power BI report using Dataverse connector

Microsoft announce that Dataverse connector is available for Power BI and tabular data stream(TDS) endpoint. Power BI users have more options when connecting to Dataverse environments, including Dataverse for Teams. The endpoint enables better relationship discovery in the Power BI dataset model. The new connector supports Direct Query providing real-time data and support for the... Continue Reading →

Export Position Hierarchy from Dynamics to Visio & Power BI

A position hierarchy is a visual representation of how positions relate to each other within your organization In this article, We will see how to export Position hierarchy. This is application for below product. Dynamics AX 2012Dynamics 365 F&ODynamics 365 HR We can export Position hierarchy with three different approach Microsoft VisioPower BIMicrosoft Excel(Not included... Continue Reading →

Embed Power BI report in Dynamics 365 F&O – Part 2

Check my previous post here about Power BI configuration, prerequisites and components needed for report. In this post, We will see how to create a Power BI report, Upload report to LCS and deploy report. We will use Microsoft cloud hosted environment to build report(tier 1 environment) with continuous updates. We have to use tier... Continue Reading →

Blog at WordPress.com.

Up ↑

%d bloggers like this: