Forum Discussion
Unable to Create Relationship in Direct Query Tables
Hi JibinSebastian,
if I understand you right, your two tables are from the same semantic model and you are connected to that semantic model from your report. In such a case it is not possible to create or modify relationsships between the tables of the same semantic model (see e.g. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models)
What you should try is editing your semantic model and add the relationship there.
Hope that helps.
Hi JibinSebastian,
if I understand you right, your two tables are from the same semantic model and you are connected to that semantic model from your report. In such a case it is not possible to create or modify relationsships between the tables of the same semantic model (see e.g. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models)
What you should try is editing your semantic model and add the relationship there.
Hope that helps.
I managed to create a shortcut in my bronze lakehouse and fetched to the power bi report now i am able to make relationship. Thank you for your response and time