Forum Discussion
Invalid unique id mapping
Hello!
I have three tables:
The table "terms" is connected to "document_terms" by unique id. These ids are 64-bit unique integers, generated across multiple partitions, so they are not contiguous, but form contiguous subsequences like (1,2,3,4,..24, 30000,30001,30002)
Somehow, Power BI maps the ids in document_term table to wrong ids in term table (but keeping one-to-one mapping). You can see it to the left, and correct mapping of similar table is at the right
Is it a known problem? What can I do to resolve it?
4 Replies
Anonymous - Not clear on what it should be doing. There isn't enough context to understand what the information in your tables represents.
Hi Anonymous,
Perhaps you can sort your column based on numeric value ASC and add an index column in the query editor.
After these steps, you can add a calculated column to look up the correspond index to other tables and extract the index as a bridge to link different tables instead of using the raw id field.
Regards,Xiaoxin Sheng
Hi Anonymous,
You can turn on the trace option to get the detail logs to diagnose:
Power BI Diagnostics, Trace Logs And Query Execution Times (Again)
In addition, you can use ssms or excel to connect to power bi data model to trace and further analytics the detailed records.
Regards,
Xiaoxin Sheng
