Data Not Fetched

[Shampa]

Hi Team,

Data is trimmed and visible in excel but upon being uploaded , it is not reflecting in BI for only 1 account out of 34 accounts.

[v-sdhruv]

Hi @Shampa ,
Just wanted to check if you had the opportunity to review the suggestions provided?
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

[v-sdhruv]

Hi @Shampa ,
Just wanted to check if you had the opportunity to review the suggestions provided?
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

[v-sdhruv]

Hi @Shampa ,
Just wanted to check if you had the opportunity to review the suggestions provided?
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

[v-sdhruv · Accepted solution]

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

[Shampa]

Apologies for late reply.

thanks a tonn !

[Akash_Varuna]

Hi @Shampa Could you check if the data model in Power BI excludes the account due to filtering or relationships

[Cookistador]

Can you see all accounts in query ?

Just to try to understand from where this issue is comming

For me, it looks like that something is wrong on Power query side