Forum Discussion

AhmerZunairSqua's avatar
AhmerZunairSqua
Frequent Visitor
2 years ago

Relationship issue

Taking Data from SQL on Direct Querry mode in tables and not null

i create a relationship but it say there is no relationship when i add a field in table view
many-to-one relationship

7 Replies

  • Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

    • AhmerZunairSqua's avatar
      AhmerZunairSqua
      Frequent Visitor

      I have multiple relationships in power bi and all the things are working fine now i have to do some changes in some reports for that i have to add a new table after i add and create relationship with but it says

      I add new table create relationship and just use one column from that table.

       

      • Khushidesai0109's avatar
        Khushidesai0109
        Skilled Sharer

        It sounds like you're encountering an issue in Power BI where you've added a new table, created a relationship with an existing table, but when you try to use a field from the new table in a report, Power BI is indicating that there is no relationship. Here are some steps you can take to troubleshoot and resolve this issue:

        1. Check Relationship Cardinality and Cross Filtering Directionp properly.

        2. Confirm Field Data Types.

        3. Refresh Data

        4. Verify Data in Both Tables

        5. Check for Errors in Query Editor

         

        Try this!

        Please give thumbs up or accept it as solution if it helped you!