Hi
I have retrieved timeseries from an asset in PowerBi. That asset is linked through a relationship column to a group of assets. However the asset and the group it belongs to are connected trough 4 steps:
groupwanted <- belongsTo - subgroup<- belongsTo - type of group <- connectsTo - group of a few timeseries assets<- belongsTo - timeseries asset
Im wondering how to link the relationships in power bi, and how to orient to the right place.
Best answer by Ankit Kumar
Cant you have a 1-1 relation between generating unit and Schedule resource’s external Ids. You can move one of the many to one relationship with Relationships table.
Hi
This is the problem, and the solution. The externalId in one table is the source_externalId in the relationship and then the target_externalId in the relationship equals the externalId in the third, view image
Cant you have a 1-1 relation between generating unit and Schedule resource’s external Ids. You can move one of the many to one relationship with Relationships table.
Hi
Just following up here from my side. Has what Ankit suggested above helped you?
Best,
Carin
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
