Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Custom Column in Table View not updating in Power Query

Hi all,

 

I have added a custom column in Power BI desktop using the related function - using the exact same formula in Power Query returns an error but works by adding a new column in the table view.

 

Is there any way to have this new column visible in Power Query when I transform my data?

 

Thanks for your help 🙂

Need Help

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi Anonymous 
    Power query and "Data view" is different "environments".
    They work in different ways and in different languages.

    Power query uses M language, Data view DAX.
    Power query is a kind of "back" environment so the changes that you make there apply to your "front", like the changes on a data source.
    But as a data view is in the front sight, it can't affect the back, this is why you can't see on pq the changes that you made in the data view.
    You can achieve a result of the related function by merging queries in power query.
    Please refer to the linked discussion:

    https://community.fabric.microsoft.com/t5/Desktop/How-to-LOOKUPVALUE-in-PowerQuery/td-p/1685419

    or to the linked tutorial

    https://www.youtube.com/watch?v=Fy0awFXKiFE

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