Forum Discussion
Key Column can't be defined in calculated tables?
By default , it is not possible.
Alternative way exists:
a) There is one more way, that you can launch Tabular Editor "TE" and change.
TE, an external tool you have to install. https://tabulareditor.com/downloads
Download the free version. You dont need to buy the latest version for this.
b) Once you have Tabular Editor installed, open .pbix file, launch tabular editor.
c) Navigate on the left to the column of the table.
Say, Delete Summary table, Source.Name is the key column you want to configure.
d) Properties window will show up.
Set the "Key" as "True"
Save and close the TE. You are good to go!
e) In the model view, you will see the key is set.
FYI, By doing this, you can see in the diagram pane and rows selection as key column. But not in the properties window. May be intentional feature by Microsoft team or a bug 🙂
Hope this helps!
Note: PBI is nothing but SSAS tabular enhanced version.
Thank you so much, my company policy won't allow this but hopefully it will help others!
Oops, I don't know any other way.
FYI, You don't need admin permission to install Tabular Editor. If the policy does not allow, it is tough.