Forum Discussion

Xfoster's avatar
Xfoster
Regular Visitor
1 month ago
Solved

Table visual error

Hi, I'm frustrated when table visual error out.  I have two fact tables, t actual, t budget.  Dim tables are t actual appended with t budget, dim proj, dim award, dim task, dim cost center.  They worked.  But when I added vendor table to fact tables, pbi table visual error out.

I don't understand why.

 

can someone help me understand this issue?

 

thanks Xiaoyan 

 

Need Help
  • Zanqueta's avatar
    Zanqueta
    1 month ago

    Hi Xfoster 

     

    I understand how frustrating this can be. To better understand what’s happening, could you please provide a bit more detail? This information will help identify whether the issue is related to ambiguous relationships, many-to-many joins, or filter direction.
     
    If that Vendor table is not one row per VendorKey, then it is not a true dimension table anymore. Once that happens, Power BI may still let the model load, but visuals can fail or return errors/incorrect results because the filter path is no longer deterministic. This aligns with the usual Power BI guidance to keep dimensions on the “1” side and facts on the “many” side, using single-direction filtering from dimension to fact.
     
     

4 Replies

Replies have been turned off for this discussion
  • Zanqueta's avatar
    Zanqueta
    Super User
    1 month ago

    Hi Xfoster 

     

    I understand how frustrating this can be. To better understand what’s happening, could you please provide a bit more detail? This information will help identify whether the issue is related to ambiguous relationships, many-to-many joins, or filter direction.
     
    If that Vendor table is not one row per VendorKey, then it is not a true dimension table anymore. Once that happens, Power BI may still let the model load, but visuals can fail or return errors/incorrect results because the filter path is no longer deterministic. This aligns with the usual Power BI guidance to keep dimensions on the “1” side and facts on the “many” side, using single-direction filtering from dimension to fact.
     
     
  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 month ago

    Hi Xfoster,

    Have you had a chance to review the solution shared by Zanqueta? If the issue persists, feel free to reply so we can help further.

     

    Thank you.

  • Selva-Salimi's avatar
    Selva-Salimi
    Solution Sage
    1 month ago

    Hi Xfoster ,

     

    What do you mean by “adding” the vendor table? Did you add vendor fields to the visual and then get an error? If so, the issue might be related to the relationships between the tables.

    Or do you mean that you appended the vendor table to the fact tables? In that case, the issue could be caused by mismatched column data types or a different number of columns.

    Could you please share the exact error message you’re getting?

     

    If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution  ✔️to help the other members find it more quickly.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 month ago

    Hi Xfoster,

    Checking in to see if your issue has been resolved. let us know if you still need any assistance.

     

    Thank you.