Report for exceptions / errors after Refresh

Hii abhijit_raghava 

You can create an exception report in Power BI by identifying records in Table A that don’t have a matching Item No in Table B. Simply create a calculated column using IF(ISBLANK(RELATED(Table B[Item No])), 1, 0) and then filter a table visual where the value is 1. This will display all unmatched records, helping you easily find and update missing entries in the dimension table.

Create a calculated column in Table A:

Exception Flag = 
IF(ISBLANK(RELATED('Table B'[Item No])), 1, 0)

Hi abhijit_raghava,

There are various ways to achieve it

1. Recomended (Less efforts)-> Power Query - Anti join exception table -> You can merge table A with table B, create join in Item No. Join type Left anti, this table will only have the rows which are not present in table B
2. Calculated table (Using DAX) - Create table using below DAX Exception Items =
   EXCEPT(
   VALUES(TableA[Item No]),
   VALUES(TableB[Item No])
   )
3. Add calculated column in table A, Mapping Status =
   IF(
   ISBLANK(
   RELATED(TableB[Item No])
   ),
   "Missing Mapping",
   "Mapped"
   )

Out of above recommended is that you create a separate table using Pwoer Query.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!