Forum Discussion
Creating my own primary keys. Data source has none.
I would enjoy anyone's opinion on using addIndex in Query Editor to use as a primary key in my dimEmployee table and dimVendor table, respectively. The data source is an Excel file that comes from a...
built-in add Index function in power query will always re-evalute its value during each data loading.
to remain indexes you should setup your ETL process correctly or (and my opinion, it maybe better) use some surrogate key like string "Vendor-Employee" or whatever you need as key
I do not see any valuable reasons to use exactly integer, not string keys
Thanks for that, and I am working to improve the ETL. It was a broad what if question to see if I would run into an issue in the short-term. Hopefully I won't have to do it this way for long.