Inconsistent RowKey Behavior in Azure Table Storage

Issue Type:
Data Query / Retrieval Inconsistency

Severity:
High (Data integrity concern affecting querying and reporting)

Description:
We are encountering inconsistent behaviour when querying our Azure Table Storage database by RowKey.

Problem Summary

• In Power BI, a row with EntityIdentifier = TestVillage appears with RowKey = RowKey_A.
• When querying Azure Table Storage using RowKey_A in Azure Data Explorer, the row is returned with EntityIdentifier = TestVillage, but the RowKey shown in the result is different: RowKey_B.
• If we try to query Azure Table Storage using the RowKey shown in the result (RowKey_B), no row is returned.

Expected Behavior

• The row should be consistently retrievable using its actual RowKey.
• The RowKey should not appear to change between Power BI and Azure Data Explorer.

Request
Could you please investigate this inconsistency and advise whether this is a known issue, a bug, or a misconfiguration on our side? Any guidance on how to ensure consistent RowKey behavior across tools would be appreciated.

I can provide screenshots if needed.

Thanks,
Jolene