swetha12's avatar
swetha12
Icon for Microsoft Employee rankMicrosoft Employee
11 months ago
Status:
New

Automate Display Name Alignment During SSAS to Direct Lake Semantic Model Migration

Migrating a report from SSAS to a direct lake semantic model. We understand that the SSAS model includes both an internal name and a display name. During migration, standard tables with dimensions transfer correctly, but fact tables are named with a '#' in the display name (e.g., '#Sales Invoice'), while the internal name is 'Sales Invoice', leading to mapping issues. 

 

We need to do manually adjust the display names in the semantic model Going through the list of fact tables and manually renaming them to match their internal names and Ensuring the mapping logic uses consistent naming convention.

Reconfiguring these will take a lot of hours.

 

Need alternative way to do this without manual intervention.

 

This improvement would: Reduce manual troubleshooting time.

No CommentsBe the first to comment

Recent ideas