Forum Discussion
Power Query converts case during import when it is not asked to do so
Hello I have an Excel file on a Sharepoint that contains sentences, and I import these data in a PBi dashboard. Problem : During import, it converts letters between uppercase and lowercase, wh...
Hi all, is this something that has been fixed by Microsoft at this moment? Or is there a workaround?
I understand that Power BI is not case sensitive and uses the first "version" it encounters for the rest of the rows. Is it possible to somehow force the order of the data load? Lets say that I only have new rows coming in when I order it by ID. By ordering by ID I can somehow steer which version of letters/phrases it uses?