Forum Discussion
what does ellipsis mean in table preview?
Hi Ceciliam ,
It means there's more data in the cell that isn't visible due to the column not being wide enough.
In Power Query, select this column then go to Transform tab > Format > Trim and see if this helps. If it does, it means your source data has 'padded' values (lots of spaces on the end) - fairly common in many application databases.
If this doesn't work, then try Transform tab > Format > Clean. This will remove any special characters (tabs, linefeeds etc.) that may be causing this issue.
*NB* If you trim/clean a primary key field in, for example, a dimension table, but do not trim/clean the corresponding foreign key in each fact table, you may find that merges between these fields no longer work in Power Query as PQ is very precise on value matching. It should not, however, affect relationships in your data model, nor DAX calculations (measures/columns etc.), as DAX tends to ignore leading/trailing spaces in values.
Pete
Hi Ceciliam ,
It means there's more data in the cell that isn't visible due to the column not being wide enough.
In Power Query, select this column then go to Transform tab > Format > Trim and see if this helps. If it does, it means your source data has 'padded' values (lots of spaces on the end) - fairly common in many application databases.
If this doesn't work, then try Transform tab > Format > Clean. This will remove any special characters (tabs, linefeeds etc.) that may be causing this issue.
*NB* If you trim/clean a primary key field in, for example, a dimension table, but do not trim/clean the corresponding foreign key in each fact table, you may find that merges between these fields no longer work in Power Query as PQ is very precise on value matching. It should not, however, affect relationships in your data model, nor DAX calculations (measures/columns etc.), as DAX tends to ignore leading/trailing spaces in values.
Pete