Power BI Relationship (send to power BI node)

[trafalgarlaw]

Hi All - may I ask why the send to power BI node when the datasets have been uploaded in power BI, there is no way to create relationship per table.

Would like to know your inputs and how to make it. Thank you!

@takbb

[k10shetty1]

Hello @trafalgarlaw,

Thank you for your question. Currently, the API doesn’t support updating relationships in existing datasets. This means that if you need to define relationships between tables, it can only be done when you’re creating a new dataset. You can establish these relationships in the Relationships tab of the node when creating the new dataset.

Hope this helps!

Best,
Keerthan

[trafalgarlaw]

Thank you @k10shetty1, do you have sample node or workflow screenshot showing that relationship tab of the node when creating the new dataset? Thank you!

[k10shetty1]

Hello @trafalgarlaw,

Here is an example of how you can do this.

Hope this helps.

Best,
Keerthan

[trafalgarlaw]

Wow will surely try this. Thanks for a new learning @k10shetty1!! Great to hear your inputs.