adding new column to excel data source

[Anonymous]

hi all
my original excel data source has column A,B,C and it working fine in dashboard.

when i added a new column "D" to the excel data source and refresh doesnt update it.

did i missed out anything?

Thank you.

[Seban]

I was facing the same problem. The issue was i had removed all the other columns except the selected column in Power Query. Check whether you have removed other columns in applied steps. If you have that jus remove that and you can see all the columns in source file. 

[amitchandak · Accepted solution]

Please refer this

https://community.powerbi.com/t5/Desktop/Power-Bi-does-not-detect-newly-added-columns-to-connected-c...

https://community.powerbi.com/t5/Desktop/Add-a-new-column-to-the-existing-data-set-and-refresh/td-p/...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[PaulDBrown]

@Anonymous 

Does the new column appear in the query editor when refreshed?

The best way to handle Excel data sources IMHO is to create tables within excel (selecting the whole range and use ctrl + t to create the table and giving it a name). You then use this table itself as the source in Power BI. If you add columns or rows to the table, you will be sure Power BI picks them up efficiently.

[Anonymous]

This has literally saved me so much time and frusteration. Thank you!

"The best way to handle Excel data sources IMHO is to create tables within excel (selecting the whole range and use ctrl + t to create the table and giving it a name). You then use this table itself as the source in Power BI. If you add columns or rows to the table, you will be sure Power BI picks them up efficiently."

[Anonymous]

I'm assuming this won't work if you already had a report built out with the xcel file in regular spreadsheet form then want to add columns and change it to a "table" format, right?

[PaulDBrown]

I don't think that would work. I would first convert it to a table, change the code for the source in the query (the easiest way is to create a new query pointing to the table and then copy/ pasting the source code into the original query. Then add columns.

[Anonymous]

@PaulDBrown no...the column didnt appear when refresh in edit queries...

Rows did get refreshed.