Forum Discussion

Xfoster's avatar
Xfoster
Regular Visitor
2 months 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 wor...
Need Help
  • Zanqueta's avatar
    Zanqueta
    2 months 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.
     
     
Selva-Salimi's avatar
Selva-Salimi
Icon for Solution Sage rankSolution Sage
2 months 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.