Forum Discussion
Cannot create relationship between one calculated table and two tables from Power BI dataset
Hi Anonymous ,
If I understand it rigth you have a Dataset based on two other Datasets or a otherDataset and another source?
It's not possible to have more than one relationship in Composite Models between other Datasets (sources).
You can put all the Datasources in one Dataset and connect them there but otherwise I gues this won't work. If I understand your problem right :).
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Hi Anonymous ,
If its a composite model you have some limitations.
Take a look here: https://docs.microsoft.com/power-bi/transform-model/desktop-composite-models
Best, Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Hi Kathrin,
Thanks for the reply. I took a look and I don't think it says anywhere that I shouldn't be able to create the relationship, or have I just missed it?
Hi Anonymous ,
If I understand it rigth you have a Dataset based on two other Datasets or a otherDataset and another source?
It's not possible to have more than one relationship in Composite Models between other Datasets (sources).
You can put all the Datasources in one Dataset and connect them there but otherwise I gues this won't work. If I understand your problem right :).
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!