Forum Discussion

pawlowski6132's avatar
5 years ago
Solved

Missing Added Column

Hi, so, I added a column to a Query in Power Query Editor. It's not available as a field in the report builder section.

 

Source is AAS and is Direct Query.

 

What gives???

 

 

Missing

I've tried all the basic solutions, refresh, etc.

 

Thanks in advance.

 

  • I saw this, happens when you do not do apply changes and saved. I assume u tried refresh all and it did not work. 

     

    Did you try adding one more (dummy) column to this table and later remove, to get the apply changes?

     

    If that does not work, best is to add another table and see if it works?

     

3 Replies

  • I saw this, happens when you do not do apply changes and saved. I assume u tried refresh all and it did not work. 

     

    Did you try adding one more (dummy) column to this table and later remove, to get the apply changes?

     

    If that does not work, best is to add another table and see if it works?

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pawlowski6132 

    Please make sure these two parameters you have enabled in Power Query.

    After you adding the custom column in Power Query ,then Close & Apply to Desktop view, refresh in Desktop and you will see the new column in report builder section .

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pawlowski6132 

    Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards

    Community Support Team _ Ailsa Tao