Forum Discussion
Adding a key to a table
Hi, I have a PBIX that contains several tables that were imported from Excel files. Each week I append data to these tables. I didn't anticipate duplicates within the table. The main key is a pat...
RenaG Potentially. You could probably create a function or otherwise extract the file creation date or what not and include that as a column in your tables. You could then create a unique key from that and your pat_ID field. Specifics are going to vary. Are you using a Folder query?
Greg_Deckler Thank you for your reply. I am a novice PowerBI developer so I don't understand your solution. Are you suggesting that in the Applied Steps on each table, somewhere at the beginning I create a column that contains the data from the pat_id and the run date? If so, how do I set that as the key for the table?