Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I load a text ID from PQ directly into Power Pivot (Excel), the case of the string is being changed.
In PQ the IDs show as "3L1AMs" and "3L1AMS", but in PP they both become "3L1AMS." What is weird, is when I filter to just "3L1AMs" (lowercase s), the row loads correctly. It is only when both are included that one is wrong after loading.
FYI, PQ also loads it incorrectly to a table. This is a PQ issue, not PP issue.
I think this is a bug and might need review from the PQ team. Thoughts?
PQ is below
PP is below
Excel table
Hi @KPMTGG - Power Query has different case-sensitivty rules to Tabular Data Model. In Power Query, "a" does not equal "A". In DAX, "a" and "A" are same. The fact that capital "S" is using instead of "s" is just that indexing was based on the first instance. Please read the following to understand why Tabular Data Model works this way: Letter case-sensitivity in DAX, Power BI and Analysis Services - SQLBI
@Daryl-Lynch-Bzy I understand that. This is a Power Query issue, not a PBI issue. When loading data from PQ into a table in Excel, not in Power Pivot, it should use the correct case, i.e. it should have a lower case S.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.