Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm working on a XML file. Some columns have values and "table".
I'm trying to transform it like this.
For step1 I get this message. Expression.Error: The column 'xyz' of the table wasn't found.
What am I doing wrong?
Solved! Go to Solution.
Found the solution. It was the use of "Source" that I had totally misunderstood. Thanks for helping me find it.
Hi @toafk ,
Instead of skipping steps, is not substituting Source by #"Renamed Columns" in your step1 what you are looking for? Otherwise, you cannot refer to any column name product of the transformations in between Source and step1.
Yes, but if I skip the rename column, I get
"Expression.Error: The column 'Sites.Site.ServiceUnits.ServiceUnit.Resources.Resource.Description' of the table wasn't found.Expression.Error: The column 'Sites.Site.ServiceUnits.ServiceUnit.Resources.Resource.Description' of the table wasn't found."
Hi @toafk ,
In step1 is your intention to apply the transformation over the "Source"?
Your column got the "xyz" name, later, in the #"Renamed Columns" step.
Found the solution. It was the use of "Source" that I had totally misunderstood. Thanks for helping me find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.