Do not force or assume transformations when Power Query gets data.
I have used Power Query as part of Power BI and Dynamics 365 Customer Insights. In both cases when Power Query is used to connect to data in Dynamics 365 (Dataverse) Power Query converts all GUIDS to uppercase.
Dynamics 365 stores GUIDS in lowercase. When Power Query forces t...
STATUS
DETAILS
New