Data Not Fetched

Hi Shampa ,

There could be multiple reasons for that.

1.Maybe for that one account, there’s an invisible character causing a mismatch.

You can use a formula like =LEN(A1) to check length.

Compare it to =LEN(TRIM(A1)) or =LEN(CLEAN(A1)).

If lengths are different, hidden characters exist.

2.Data Type mis-match-
Check- In Power BI > in Power Query Editor > see the datatype of the column (Text/Number).

3. Filtering/Transformation Error:

Maybe while importing into Power BI, a step in Power Query is unintentionally filtering out that account.

Check Applied Steps in Power Query.

Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You