Column only showing in the Report/table view

[VJ_Lsf]

I have a column that is only displayed in the Report/Table and model view in PBI desktop. It is not a measure. I can't find this column in Power Query, the data source SQL statement, or the Advanced editor. There are no Applied steps in the Query editor. How do I know the source for this column or find the DAX on how this column is generated. Attached screenshot below. Thanks in advance.

[VJ_Lsf]

Thank you so much @Uzi2019 for the response. I opened the power query editor and refreshed the data. I don't see the 'Open SO' column returned from data source and there are no applied steps renaming the column. It has values in $currency format. Please see the screenshots below. I also ran the same query on the database in SQL dev and don't see this column. This report was developed in 2021 but never used. I opened it in PBI desktop Jan 2025 version. Thank you for all your help.

[v-jingzhan-msft]

Hi @VJ_Lsf 

It's quite strange. Can you check the column name in Power Query Editor again with the following method? 

Create a blank query, paste the code into the formula bar to list the column names that contain "Open" string in the table #"Open Orders". 

= List.Select(Table.ColumnNames(#"Open Orders"), each Text.Contains(_, "Open"))

Or list all column names of the table #"Open Orders".

= Table.ColumnNames(#"Open Orders")

In addition, could you share the sql query used to query data from the table or database if possible?

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[VJ_Lsf]

Thank you for the reply. I tried code above in power query to display columns returned in the query. There is no "Open SO" column in the results.

[v-jingzhan-msft]

Hi @VJ_Lsf 

It's weird. I compared the results in the screenshots and found that "Open SO" is not the only one, there is another column "EST_REVENUE" that only exists in Power Query Editor. Can you check the values in both columns? Do they have same values?

Best Regards,
Jing

[VJ_Lsf]

Hi @v-jingzhan-msft  Thank you for the suggestions. I tried the code you shared above. I'm not seeing the column being returned from query. This is querying Oracle financials database.

[Uzi2019]

Hi @VJ_Lsf 

Are you using a latest version of PBI desktop???

Suggestion:

Can you open power query and refresh your data then check whether you have this column or not??

Pleae check this steps whetehr you have renamed it or not???

Can you take a refresh one more time on desktop?? just for verification if this column is deleted from SQL then definitely it will break..

This column is not calculated neither Measure nor calculated column. This is coming directly from datasource .

Does it has any value like 1 2 3 or 0??

beacuse this is numeric column. 

I Hope I answered your question!