Issue with Data

[stokercw]

Why does Power BI Desktop change case?

My data is case-sensitive:

DATABASE_NAME                                                    ARCHIVED_DATE
---------------------------------------------------------------- --------------------
EPCD13D                                                          17-DEC-2017 12:00:00
epcd13d                                                          25-DEC-2017 12:00:00
epcd13p                                                          17-DEC-2017 12:00:00
epcd13p                                                          25-DEC-2017 12:00:00
epcd13sby                                                        17-DEC-2017 12:00:00
epcd13sby                                                        25-DEC-2017 12:00:00
epcd13t                                                          17-DEC-2017 12:00:00
epcd13t                                                          25-DEC-2017 12:00:00

When I pull this into a table visualizaion:

Is this a BUG, FEATURE, or PEBKAC?

[Rfranca]

hi,

As you have different date for the same DATABASE_NAME lines appear this way.

In case you want to see by date apply an appropriate training.

If you use some aggregation function you can see by YEAR, MONTH, DAY, etc.

[v-qiuyu-msft · Accepted solution]

Hi @stokercw,

I have consult the same issue from PG team before. This is by design. Data model isn't case sensitive.

You can also find the same issue has been talked in forum many times, see: http://community.powerbi.com/t5/Desktop/Creating-Case-Sensitive-Table-Relationships/td-p/18210

Best Regards,
Qiuyun Yu