PowerBi seems to lose state of connection depending on the field I pick

[Anonymous]

I have a model with multiple tables. Four tables:

Two tables:

    FactLocation
   DimLocation

Are connected on:

LocationKey

And two more tables:

    FactPurchaseOrder
    DimPurchaseOrder

Are connected on:

PoKey

In addition:

    DimLocation
    FactPurchaseOrder

Are also connected on:

    LocationKey

I have a table view, that I would like to use columns from all tables for.

I started out adding items from

    FactLocation
    dimLocation

everything was going fine. Then I added one column from

    FactPurchaseOrder[OrderQuantity]

And that went fine. Then I tried to add:

    FactPurchaseOrder[OrderDate]

Initially, I see that it recognized the date format, and it shows me, under Values, the OrderDate and underneath it Year, Quarter, Month, Day fields, but I also get the following error message, inside the Table visual:

Can't display the visual
Relationship Detection
There is a missing relationship between these fields. Use autodetect to search for relationship, or create them manually.

If I click on autodetect, it tells me No relationships were detected.

The same happens to the other columns from that table.

Any idea what I should be looking for? there is a relationship between the tables, and at least one field was allowed.

[V-lianl-msft]

Hi @Anonymous ,

Unfortunately, I can't reproduce your issue.

Did it happen by chance?

You can try to use the crossfilter function to get the columns in the corresponding table.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I am going to re-write this question, and include all the information

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Thanks for your update.

https://community.powerbi.com/t5/Desktop/Parts-of-table-not-capable-of-resolving-connection/m-p/1190089#M533921 

As the issue is resolved. I will close this thread.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Please make it one-directional unless there is need for bi-directional

Make it one - Many from Dim to Fact. Even though it seem like 1-1 as of now