Hello folks,
I have a situation where I imported a SharePoint folder using Data flow, and when creating the custom column at the first time the Dataverse table was being created, the custom column is added with no problems. After publishing the query, when I come back to the query editor and try to add a second custom column, it gives me no error, but the column does not appear on the Dataverse table.
"productStatus" is the custom column I created when the Dataverse table was created;
"test" is the second custom column I created after the Dataverse table was created;
"test" supposed to be populated with the data from "productStatus";
"test" is just referencing the column "productStatus" ( =[productStatus] ). Simple as that! It works on the query editor.
I imagine it could be related to the table schema/mapping. So I created a new column with the same name of the custom column and accessed the power query editor one more time. Right before publishing, I see the column I created, then I linked the custom column to the new column created on the Dataverse table.
Column "test" is mapped to the correct destination column.
The problem is that no matter how many times I refresh, publish, or save, the data in the custom column is not populating the column on the Dataverse table.
The advanced query editor is referencing the last column below "in." So, I don't think that's the issue.
