Forum Discussion

david2's avatar
david2
Helper I
9 years ago
Solved

Auto-renaming columns based on value in another table

Hi all,   I have connected PowerBI to our CRM software (Pipedrive). I pull data relating to our customers / deals from Pipedrive using a JSON API call. Each deal / customer is saved as an object wi...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi david2,

     

    After looking into the pbix file and JSON files you shared with me, I found several issues you may need to pay attention to.

     

    1. Use formula below in your Advanced Editor.

        #"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",Table.ToRows(fields))
in
    #"Renamed Columns"

    Not

        #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",Table.ToRows(fields))
in
    #"Renamed Columns"

    2. As a table cannot have two columns with the same column name, please make sure all values of "name" column in "fields" table are unique and not already exist in "deals" table.

     

    Here are the modified pbix file and JSON files for your reference.

     

    Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi There,

 

I know this is an old post, but I am hoping you can help me.  I am getting the same error after creating my table of header names.  I am wondering how to fix once and for all.  I have tried multiple ways to do this, but with no luck so far.

Expression.Error: We expected a RenameOperations value.
Details:
[List]

RobinNeven's avatar
RobinNeven
Helper I
3 years ago

I know this is an old thread, but for me the trick was to convert the key field in Table1 (which in my case contains numbers) to text data type 🙂