Todd Chittenden on 15 Jan 2025 17:23:55
(Disclaimer: I am submitting this under the first Product and Category set that will allow it. I tried the Power BI Product, but the Categories would not load for me to select one. This site is horrible!)
Power BI data needs to support CASE SENSITIVE data. There are plenty of datasets out there that are CASE SENSITVE. But Power Query just doesn't care and will assume the "AA" is the same as "aa" and tell you that you have duplicates in that column.
Worse, the M language IS case sensitive!