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 : https://powerbi.microsoft.com/en-us/blog/newdatasets/.
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!