Forum Discussion
Data Activator and Primary Key
Hi DennesTorres ,
If a single primary key is not available, consider assigning multiple data streams to a single object, ensuring the key column chosen references the same object IDs used when the object was initially created.
If you point to a field that is not a primary key, there could be challenges in ensuring the uniqueness of each object, which may lead to inaccurate data association, monitoring, and analysis. The integrity of the data and the correct functioning of properties and triggers related to the object might be compromised. Therefore, it's essential to choose a key column that can uniquely identify each object to maintain the integrity and accuracy of the data being monitored.
For more details, refer: Assign data to objects in Data Activator - Microsoft Fabric | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DennesTorres ,
If a single primary key is not available, consider assigning multiple data streams to a single object, ensuring the key column chosen references the same object IDs used when the object was initially created.
If you point to a field that is not a primary key, there could be challenges in ensuring the uniqueness of each object, which may lead to inaccurate data association, monitoring, and analysis. The integrity of the data and the correct functioning of properties and triggers related to the object might be compromised. Therefore, it's essential to choose a key column that can uniquely identify each object to maintain the integrity and accuracy of the data being monitored.
For more details, refer: Assign data to objects in Data Activator - Microsoft Fabric | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you!
In the end, the question was too basic because the name "primary key" was puzzling me. It's not a "fact" primary key, but a dimension primary key, which identifies the object but naturally it will repeat many times on the stream.
Kind Regards,
Dennes