How can you hide a column in Power BI while using a live connection?
I’m using a live connection in Power BI and need to hide specific columns from being displayed in reports for confidentiality reasons. However, since the data model is managed on the server side, I’m unsure how to achieve this within the constraints of a live connection. Could you explain the best way to hide or restrict access to columns in such scenarios?