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 →
Top 10 Power BI training resources for beginners
In this article, I will give you the top 10 Power BI training resources for beginners. For those who want to learn Power BI or start a career in Power BI then it is quite useful for you. Training courses MICROSOFT LEARN FOR POWER BI Microsoft learn provides a variety of Power BI tutorials from... 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 →
Display employee images from Dynamics 365 F&O/ HR in Power BI
A good way to enhance your reports is to add images to them. Static images on the page are good for some purposes. But sometimes you want images that relate to the data in your report. In this article, we will see how to display images from Dynamics 365 F&O/ Human resources in Power BI.... 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 →
Create a Leave and Absence Report in Dynamics 365 HR
Currently, it not possible to modify a Power BI report embedded inside Dynamics 365 Human Resources. There is however, a workaround to create such a report. In this article, we will show you how you can create a Leave and Absence report in Dynamics 365 Human Resources. But before we start, we have to understand 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 →