Columns are commonly known in architecture and structural engineering as pillars that support houses and walls. In architecture, "column" refers to a structural element that also has some proportionate and decorative features. This is how columns in database tables work. Columns are a way to store a discrete piece of information within a record in a table.  In the Dataverse, Columns define the individual data items that can be used to store information in a table.   There are three type of column in the Dataverse: Standard Column Managed Column Custom Column Standard Column: When we create the table, 19 columns are created by the system and those columns cannot be deleted. All these columns are managed by the system. Managed Column: Managed Solutions allow the developer to use Managed Properties to "lock down" certain features or definitions of objects in CRM to prevent end users from introducing problems or altering the product in an undesired way. Custom Column:  ...

The concept of relation (database relation) was given by E F Codd in 1970 and nowadays, it is the soul of database. Relationships are  a logical relationship between different tables, which is established on the basis of the interaction between these tables. Relationship helps to make more efficient and scalable solution. Microsoft Dataverse is a relational database that is managed by Microsoft in the cloud. Table relationship refer to metadata that is used to make changes to the database. these relationships assist queries to retrieve related data efficiently. With the table creation, Dataverse provides the interface to create the relationship between tables, Relationships between tables exist in many forms, but the two most common are one-to-many and many-to-many , both of which are supported by Dataverse. There are two types of table relationships: One-to-many relationships(1:N or N:1): A primary can be associated with multiple reference (related) tables. The primary table row ...

Business units are core components of security model and these components work like framework on which a security model is built. These components provide security and structure for grouping users and are often used to replicate the departmental or division structure of an organization. Each user assigned to a Dataverse environment will belong to a business unit. The first business unit created for an organization is called the root business unit. Business units can be deleted, however, the root business unit cannot be deleted.  System Administrator has full permission to customize or administer the environment, including creating, modifying, and assigning security roles and can view all data in the environment.   A Business Unit is a logical grouping of related business activities. It is the foundation of the security structure in the Microsoft Dataverse. Each user must be part of a business entity. There is a default business unit that is created when a Dataverse d...

The security model is the key factor in Dataverse security that provides remarkable and extensible advantages in a competitive market. In the business world, data acts like fuel and data protection is a more formidable challenge than mining data in the current markets. It is important to build a security model that ensures proper use and access to valuable assets.  One of the key features of Dataverse is its rich security model which can adapt to multiple business usage scenarios. This security model only comes into play if the environment contains a Dataverse database. Security Roles are fundamental unit  of data security in Dataverse. The fundamental concept in role-based security is that roles have privileges that define a set of actions that can be performed within the organization. In the security pyramid of Dataverse, Security Roles come as base security which protect the data as well as give the right access permission to authenticated users. Each security role consis...

In the era of digital transformation, security is a major concern. Cyber ​​hackers easily target any application and system. They exploit important information that can damage an organization's business plan or reputation. Security is not a one-time establishment, it should be reviewed from time to time. for example; Sometimes, former employee credentials work into current business applications that provide unauthorized access with a legitimate process. Operational security is an analytical and strategic process used for risk assessment and management to identify information that can be used by attackers and against an organization's business and reputation. There are a few key areas that can be considered in operational security: Unencrypted Credentials Logs and Events anomalies Permission issue Access Violation Misconfiguration setting and devices Weak security configuration  Microsoft provides a next generation business process automation and productivity suite known as Powe...

The World Wide Web (WWW) was created in 1990 by British CERN physicist Tim Berners-Lee. This year was a revolutionary point in world history, as it changed the whole world in terms of communication. Nowadays, millions of web sites, pages and content are being created every day.  As web applications and web sites emerged, HTML, CSS and JavaScript are major players in the client side. Ajax and jQuery make the whole web world more responsive and interactive. Microsoft understands the capabilities of these technologies, so they allow web resources to be created in Power Platform. Web resources are virtual files that are stored in the Microsoft Dataverse database and that you can retrieve by using a unique URL address. Web resources represent files that can be used to extend Dataverse web applications such as html files, JavaScript and CSS, and many image formats. We can use web resources in form customization, sitemaps, or application ribbons because they can be referenced using URL sy...

Portal is the generic term in science fiction movies where astronauts enter a universe in another universe. It seems the same in the Power platform which gives an external point of view for the audience and users of the outside world. On 1 October 2019, Microsoft launched Power Apps Portal which has the capability to create low-code, responsive websites that allow external users to interact with data stored in the Dataverse. There are many portal templates available which can be provisioned according to the target audience and workload. The Power Apps portal requires that there is a Dataverse database available in the environment for key components to be installed and configured. Core Power Apps Portal Features: Content Management (Web pages, static text, image and other context) Multi Languages (43 languages) Access to Dataverse data Themes Global Search Authentication and Security Profile Management Customization and Extensibility Although the whole features are interesting and busi...