Skip to main content
Solved

Relationships in powerbi


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.

 

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img
  • Senior Cloud Architect
  • August 15, 2022

Hi @Andreas Aandahl Ranje can you please clarify more in details (like with some table examples), Power Bi has got it own sets of limitation when creating relationships. With Cognite Data Fusion resource types (ie. assets and timeseries) you have Asset ID column to link between Asset and Timeseries. 


Forum|alt.badge.img

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

 

 


Forum|alt.badge.img
  • Senior Cloud Architect
  • September 7, 2022

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.

 


  • Seasoned Practitioner
  • October 4, 2022

Hi @Andreas Kimsås,

Just following up here from my side. Has what Ankit suggested above helped you?

Best,

Carin


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings