Power Query Append problem with new fields

[apelleti]

Hi everyone,

I have Two tables loaded in Power Query: Results2021 and Results2022. I appended the two tables "As new table". After appending, I added a new field  "Dataset_Ref" and input "Previous" in the Results2021 table and "Current" in the Results2022 table. I expected the "Dataset_Ref" field to appear in the appended table so that I could use it as a filter in Power BI, but it did not appear. I have tried creating this field directly in the appended table and it did not work. I also created this field in the table view of Power BI but it would not work as a slicer. Can someone tell me why the new field is not appearing in the appended table and how to fix it? 

Thanks!

Thank you!

[SamInogic]

Hi,

As per your requirement there are two tables Results2021, Results2022 as shown in below screenshot.

You have appended the both tables in New Table and then added DatasetRef Column in both Results2021, Results2022 table.

If you have added this column in Data View area then those columns will not be available in the Query Editor or added in new Appended table. You have to add that column in the Power Query Editor.

Please refer to the below screenshot.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Services

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/  

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[apelleti]

Hi @Samlnogic , 

Thanks for your response! I added the Dataset_Ref fields in PowerQuery after having already appended the two tables. I realized after appending that I needed them, but have already done a lot of work on the appended table in dataview and do not want to start over. Are fields added after the append not automatically added to the appended table? 

Thanks!

[SamInogic]

Hi,

The fields will be added in Appended table automatically; even we add those after Append Query in Power Query Editor.

So, can you once check within Go to column property in the Power Query Editor to see if the custom column is listed over there?

Navigate to View tab and click on Go to Column, find the custom column and click ok.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Services

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/  

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[PhilipTreacy]

Hi @apelleti 

Have you checked the sample file I provided?  

If you added a column in Power Query after appending the tables, then that column will appear in the new appended table - as you can see in the example file I created.

If you are not getting the same result then I need to see your file as I can't understand why you would not see this new column.  You say that you :

'added the Dataset_Ref fields in PowerQuery after having already appended the two tables.'

If that's the case then the new column should appear in both the Power Query editor and in the Data View of PBI and be available to use as a slicer.

Regards

Phil

[PhilipTreacy]

Hi @apelleti 

Download example PBIX file

I've recreated the steps of your query and had no issues.  It's not clear what you are doing as you haven't supplied any code or data.

When you say you added a 'field' -  do you mean a column?  And if that is true, are you doing this in Power Query or in DAX?

If you are adding a column, I can't see why it isn't available to use in a slicer/filter.

Please supply your PBIX file so I can see what you are trying to do.

Regards

Phil