Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lukeh1995
Frequent Visitor

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 🙂

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @lukeh1995 
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.

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.