If you are unable to see the extra data you added to the query in PowerBI, then you will need to check:
In the Power BI, Query section, click Edit.
Convert to table settings to check the extra column is highlighted.
If not, then highlight this column, then click Save.
If this fails, recreate the PowerBI query.
📌Note: If your query name contains special characters, rename the query before exporting this again.