Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a dimension that is polulateded using a select distinct on a text column, something like:
select distinct UPPER(colname) from tablename)
PowerBI is telling me a duplicate in the dimension on the one side of the relationship. Investigation shows that there is a value that is almost a duplicate, but one has a tab at the end, the other has not ( e.g. below, where -> represents the tab as i cant paste a tab into the forum).
Value
Value->
So it seems that Power query recognises the tab, and loads the value, but then outside of powerquery, powerbi does not recognise the tab, and sees the value as a duplicate value in a dimension.
To work around this I have had to:
-in Power query - Clean text (remove unprintable chars from the string)
-in Power query - Remove Duplicates.
Is there a disconnect between how powerQuery and PowerBi deal with non printable characteres?
Solved! Go to Solution.
@wilson_smyth wrote:
Is there a disconnect between how powerQuery and PowerBi deal with non printable characteres?
Yes, the tabular model strips trailing whitespace characters when it stores the data, Power Query does not do this.
Your workaround is a valid way of dealing with this scenario.
You can go to transform tab -> click replace values to replace the unprintable values to printable values:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@wilson_smyth wrote:
Is there a disconnect between how powerQuery and PowerBi deal with non printable characteres?
Yes, the tabular model strips trailing whitespace characters when it stores the data, Power Query does not do this.
Your workaround is a valid way of dealing with this scenario.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |