Forum Discussion

Frequent Visitor

6 years ago

Filters and slicers affecting this visual. Not picking up friendly names?

When connecting directly to SQL or SSAS the friendly business names are not always being picked up in the viz when filtering? Sometimes it picks up some of the friendly names but not always? ...

Icon for Super User rank

Super User

6 years ago

EamonT , You are doing a visual level rename . Rename them under fields pane (Rightmost pane). That will be global rename

EamonT
Frequent Visitor
6 years ago
amitchandak thank you for your reply - indeed I now realize it is possible when it is an SQL direct query, a rename option is there but my main use case is SSAS Connect Live and it doesn't appear to give me the rename option on the far right pane when it's SSAS ?

Thanks.
- v-lionel-msft
  Community Support
  6 years ago
  Hi EamonT ,
  
  Yes, you cannot rename the field when you use the ‘Live Connection’ connection mode. Because the connection information in this connection mode cannot be modified, just as you cannot use the ‘Advanced Editor’.
  
  You can modify the field names before connecting the model. For the 'Live Connection' connection mode, the data modeling is completed before connecting the model.
  
  Best regards,
  Lionel Chen
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - EamonT
    Frequent Visitor
    6 years ago
    Hi v-lionel-msft thanks for your reply - appreciate it is better to change names in SSAS but in my use case that would be difficult.
    Here is the same table, in one case working the other not, so it seems changing the viz names can work but not all the time?
    
    Working (Picking up the viz name changes)
    Non-Working - same report, same viz ... (Not picking up the viz name changes?).
    
    Thanks.