Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
10 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
10 months ago

Ok any tools for doing this without destroying visuals ?

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

    Hi jaryszek ,

    You can use the Fabric notebooks by using the PySpark code to change the column names of a table in Lakehouse. Please refer below PySpark code. to rename the column names.

     

    spark.read.table("tableName")\
    .withColumnRenamed("oldColumnName", "newColumnName")\
    .write\
    .mode("overwrite")\
    .option("overwriteSchema", "true")\
    .saveAsTable("tableName")

     

    Please refer below example.

     

    1. I have created sample data in Lakehouse.

     

     

    2. Created a Notebook, and run the below sample PySpark code to rename the column names.

     

     

    It will change the column names and save the Notebook. And then refresh the table in Lakehouse, it will reflect the changes.

     

    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
      10 months ago

      thanks, let's do not close topic, maybe somebody will propsoe another tool also.

      Best,
      Jacek

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

        Hi jaryszek ,

        Thank you for the update, we will keep this thread open while continuing to look for alternative solutions.  If you discover any workaround , kindly post them here, as it could benefit other community members.

         

        Regards,

        Dinesh