Power BI Table Relationships

[TardisPilot]

Hey All!

I am thrilled by the Send to PowerBI node and how easy it is to use. In building out a PBI dataset though, I noticed that there is no way to setup the relationships between my columns.

As far as I understand, once the dataset is in PBI Service via PUSH there isn’t much we can do with it.

There is an old article out there that shows how the relationships can be managed inside of the PUSH itself : New features for the Power BI Dataset API | Microsoft Power BI Blog | Microsoft Power BI.

Is this something that can be brought into the PBI node, or does it already exist possibly?

If anyone has other ideas around creating relationships between tables in a PBI dataset I would sure appreciate your thoughts!

[bwilhelm]

Hi @TardisPilot,

I am glad to hear that you like the node.
Currently, it is not possible to define the relationships in the node. We are now discussing this feature and I will keep you up to date (maybe we will manage to get it implemented for the upcoming release).

There is a kind of cumbersome workaround to allow you to create datasets with relations right now. You need to create the dataset with all tables, columns and relationships in advance with the API (Note the “Try It” button on the REST API reference page). Then, in KNIME, you can configure the node to append to the existing dataset.

Best
Benjamin

[ipazin]

Hello @TardisPilot,

in case you haven’t seen it new KNIME version 4.4.0 offers defining Power BI table relationships. See here for more:

PowerBI Integration

Hello @dpowyslybbe, @Haystack, @rafaelesanto83 and other Power BI users, with new KNIME version 4.4.0 Send to Power BI node has been enhanced with possibility to define relationships. Additionally it has been moved out of Labs. Give it a try and as always feedback is welcome! Check out here for more together with list of other nodes moved out of Labs: Br, Ivan

Br,
Ivan

[Farzad_Vahidi]

Hi all,

Send to Power BI node can significantly improve the process of uploading data to Power BI dashboards, however, it seems to me that the configuration you apply regarding the tables relationships is not effective at the end. When I look at the uploaded model, the relationships between the tables are different from what I applied in KNIME. Does anyone know how it works?

[ScottF]

Hi @Farzad_Vahidi and welcome to the forum. Tagging @bwilhelm here since he is the expert on the node.

Shifting gears to tag @tobias.koetter instead

[Farzad_Vahidi]

Thanks @tobias.koetter in advance