There is an issue with MDS 2012 and business rules with a combination of “must be unique” attributes. If you do not list the attributes in the same order that they were created you will get a generic error message when trying to re validate your data.
The work around for this is to recreate the “must be unique” combination of attributes in the same order as the attributes shown in the leaf attributes list. The screenshots below provide an example of the issue and solution.
In the first screenshot below we have a unique constraint containing Customer Type and Order Type. In this scenario we wanted to add Brand to the uniqueness constraint.
We can drag and drop “Brand” from our entity specific attribute list onto our combination, save, and publish the updated business rules without problem.
Once the new rules have been published a question mark will appears next to all rows of data for the entity that the business rule covers.
When we click on apply rules to re-run the business rules and validate the data we get the following error message.
As mentioned above the work around is to recreate the unique constraint with the attributes in the same order as they appear in the Entity Specific attribute lists.
In our example that means recreating the unique constraint so that Brand appears above Customer Type and Order Type.
Once the re-ordered rule has been published, applying it to the entity will work without error once more.
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr