Forum Discussion

PowerBIRyan's avatar
PowerBIRyan
Regular Visitor
6 years ago

New Columns Not Appearing in Query Editor, recreating formula in Query Editor is giving an error

I've read that there are issues when bringing in new columns to query editor so I am trying to recreate the column from within the query editor using the same formula. I am getting an error and not familiar with how to properly recreate the formula (below) in query editor, or maybe it's something else I'm doing wrong?

 

 

Need Help

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Try changing the data type in the Query Editor first?

     

     

    • PowerBIRyan's avatar
      PowerBIRyan
      Regular Visitor
      6 years ago

      Thanks Anonymous , I checked and everything im referencing in the formula is Whole Number. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Can you see if the following works 

        = Table.AddColumn(#"Added Custom", "Merged", each Text.Combine({[project)id], ", ", [cost_code_id] ", ", [line_item_type_id]}), type text)

         

        or the following

         

        = Table.AddColumn(#"Renamed Columns1", "Merged", each Text.Combine({Text.From([project_id], "en-GB"), ", ", Text.From([cost_code_id], "en-GB"), ", ", Text.From([#"line_item_type-id"], "en-GB")}), type text)

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    PowerBIRyan - Check your Source line in Advanced Editor. Often, there is a setting that specifies the number of columns to bring in (definitely the case for CSV files).

    • PowerBIRyan's avatar
      PowerBIRyan
      Regular Visitor
      6 years ago

      Thanks Greg_Deckler, I have and was not seeing one so I decided to try to recreate the column in query editor instead.

       

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    PowerBIRyan - You could also use Number.ToText or similar conversions in your formulas to wrap your columns potentially. 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi PowerBIRyan 

    If this formula doesn't work?

    =Number.ToText([project_id]) & "," & Number.ToText([cost_code_id]) & "," & Number.ToText([line_item_type_id])

     

    Regards,

    Lin