A new feature is coming this year and is only available as preview for the moment. You are now able to connect your Dynamics 365 database. This SQL connection provides a read-only access to the CDS environment. You can see each column type of each entity and you can execute SQL request directly in the databases.
Step by Step deep dive: The CRM can store a huge amount of data. A Business Intelligence tool such as Power BI allows to retrieve meaningful information from this data and helps companies to improve their business.
In consequence, more and more people show their interest about the association of Power BI with Dynamics 365. So, this Chronicle will expose different ways to embed Power BI in Dynamics 365.
Charts in Dynamics 365 are a graphic representation of data from multiple records of an entity. The data comes from a view – meaning it can be filtered data – and enables users to understand key performance metrics of their business in real-time
Interactive Dashboards have been released with Microsoft Dynamics 365 V9. Interactive Dashboards are like the regular dashboards in Dynamics 365, but with some improvements like field-filters, time-spanning filters, real-time data updates, count-aggregates and integrated quick actions for records.
FetchXML is a query language used in Dynamics 365 and in the Common Data Service. It’s expressed in an XML format with some aggregation capabilities, like sum, average, or total. This language supports filters upon the main entity but also filters upon linked entities