Forum Discussion

Zulaikha's avatar
Zulaikha
Frequent Visitor
1 year ago
Solved

Join path are expected to form tree

Hi All, I am getting the following error when I'm embedding my report with RLS using service principal. However in PowerBI desktop it is working fine. Below are the connection that I'm u...
  • Bibiano_Geraldo's avatar
    1 year ago

    Hi Zulaikha , 
    As indicated in the error message, there are two relationships between the Fact Terminal and Dim Ministries tables through the Ministries ID column, as highlighted in the images below:


    Now what you need to do, its remove one of these relationships and check if the error is resolved.
    You can learn more about star schema here 

     

    I hope this helps! 🎯
    If you found this answer helpful:
    βœ”οΈ Mark it as the solution to help others find it faster.
    πŸ‘ Give it a kudo to show your appreciation!