Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
11 months ago

How to update field names using XMLA for all visuals without power query?

Hello, I am using Direct Lake over OneLake - how to rename columns using XMLA without power query possibilities which is disabled in Direct Lake mode?  It is possible or fileds should be rename...
Need Help
  • jaryszek's avatar
    jaryszek
    Icon for Super User rankSuper User
    11 months ago

    It is not possible in Tabular Editor 3? 

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      11 months ago

      Hi jaryszek ,

      Thank you for reaching out to the Microsoft Community Forum.

       

      Yes, it is possible to rename columns in Direct Lake mode using XMLA.

       

      1.  Use Tabular Editor 3 (Enterprise Edition) to rename columns via XMLA, but ensure you first rename them in the web interface to prevent reversion during schema sync.

       

      2. Rename columns upstream in the Lakehouse or Warehouse before adding them to the semantic model.

       

      Please refer below link.

      Power BI usage scenarios: Advanced data model management - Power BI | Microsoft Learn

       

      I hope this information helps. Please do let us know if you have any further queries.

       

      Regards,

      Dinesh

      • jaryszek's avatar
        jaryszek
        Icon for Super User rankSuper User
        11 months ago

        1.  Use Tabular Editor 3 (Enterprise Edition) to rename columns via XMLA, but ensure you first rename them in the web interface to prevent reversion during schema sync.

        Ok there is a displayName but after changing it i need to manually adjust fields on report visuals, how to avoid this?

        Best,
        Jacek