My question has to do with the process flow for initially assigning the primary and foreign keys. I feel very comfortable how to create indexes and use power query to set up course work scenarios but when you approach a data warehouse situation, is the assigning and maintenance of these keys with the Power BI developer ( me ask data warehouse to implement them) or is it proper to ask that part to be dome further upstream?
Apologies for the run-on sentence!
I was thinking the initial keys would be on my end but could use some input on how to approach in the beginning.
Thank you in advance.