Create an alias for columns that will be usable by all users.

julsr well you need to ask yourself first - do you want users to give access to the database or you want to create a Power BI model and then they use that.

If it is first one then use SQL views as per my previous reply.

If 2nd option then it is easy, create a data model in Power BI, rename columns, and then publish the dataset to the service and let users connect to that dataset and use the columns from already renamed columns.  For this, you have to think thru who owns the model, who will do these modifications to the model, what if users want to use the data which is not part of the dataset. So many things to plan and work thru with option but it is feasible.

It is not an easy question to answer without knowing how you are implementing the BI solution.