Forum Discussion
Data Not Fetched
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.
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
7 Replies
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 YouApologies for late reply.
thanks a tonn !
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
Hi Shampa Could you check if the data model in Power BI excludes the account due to filtering or relationships
