Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Error from relationships (pbi atchd)

    Bronze Contributor
    Posted Dec 17, 2021 05:28 AM
      |   view attached

    Hi ,
    I am stuck in this problem.



    attaching pbi with this. Can pls someone clear this issue



    ------------------------------
    Anubhav Mahule
    Lead consultant
    ------------------------------

    Attachment(s)



  • 2.  RE: Error from relationships (pbi atchd)

    Top Contributor
    Posted Dec 17, 2021 08:56 AM
    Hello:

    Beats Visits and Beats Orders look like Fact Tables and should both be on the many side of the relationship (*) and connect to your date table. The error message is explaining this.

    The other potential option is that Beat Orders only connects to Data Table and Beat Visits only connects to Beat Orders on ID.

    Basically your LOOKUP Tables like DATES should have only unique values where as your FACT Tables have transactional type data with one or more entries for any particular date.

    As an aside Date/Time should be separate columns and treated separately. Your models should strive for One to Many or Mant to One relationships and not di-directional unless you really know what's going on. Here is a basic format that can help you visualize this approach. Every LOOKUP or DIM table has only unique records and the primary key that filter the Fact Tables below(the many side).

    I hope this helps.



    ------------------------------
    William Skelley
    01106
    Longmeadow MA
    8602807221
    ------------------------------