Hi AllMy customer table suddenly display like error sign , may i know how to remove it ? the system still running fine. Red triangle

admin11 It looks like the data for the field failed to load. Check the query for the table in Power Query and see what the error is.

PaulDBrown This table is just link table , table not available at PQ. Paul

admin11 Try changing the DAX to: Customer = DISTINCT(UNION(DISTINCT(AR[Customer/Vendor Code]), DISTINCT(Sales[Cust_ID)))

PaulDBrown This happen when i relfresh the data.when i take those old file one month ago and reload , the error from Customer Table will happen. Paul

My Table suddenly display error sign ? | Microsoft Fabric Community

PaulDBrown
Community Champion
5 years ago
admin11

It looks like the data for the field failed to load. Check the query for the table in Power Query and see what the error is.
- admin11
  Memorable Member
  5 years ago
  PaulDBrown
  This table is just link table , table not available at PQ.
  
  Paul
  - PaulDBrown
    Community Champion
    5 years ago
    admin11
    
    Try changing the DAX to:
    
    Customer = DISTINCT(UNION(DISTINCT(AR[Customer/Vendor Code]), DISTINCT(Sales[Cust_ID)))
- admin11
  Memorable Member
  5 years ago
  PaulDBrown
  This happen when i relfresh the data.
  when i take those old file one month ago and reload , the error from Customer Table will happen.
  
  Paul
SrivallyBhagi
Frequent Visitor
1 year ago
Hello, Did your problem got resolved ?
SrivallyBhagi
Frequent Visitor
1 year ago
Hello,
Can you please assist me in resolving the issue with the red warning appearing for all the tables in the model layout? I created a new lakehouse, but I’m still encountering the same issue in the new lakehouse.
Regards
Srivally