Last week a new issue cropped up in production ...The DataAreaID (aka Company ID) is now showing in lower case on exported data for all new transactions and master data. I checked a number of things and I am at a complete loss as to what has changed. (as an example, the Company ID changed from 'SAC' to 'sac' )
Generally, this would not be an issue, but this field is used extensively for foreign keys and is now not playing nice within the Power BI (Power Query analysis server is case sensitive). It is easy enough to address with yet another layer of ETL to standardise the text case. But this should not be happening ....Any Ideas ???
If you've found this thread useful, dive deeper into User Group community content by role